On Fri, Jul 1, 2011 at 6:54 PM, Mark Murphy <[email protected]> wrote:
> Then use multiple question marks. Or, better yet, use the insert()
> method to insert data into a database:
>
> public void insert(String name, String address, String type, String notes)
> {
> ContentValues cv=new ContentValues();
>
> cv.put("name", name);
> cv.put("address", address);
> cv.put("type", type);
> cv.put("notes", notes);
>
> getWritableDatabase().insert("restaurants", "name", cv);
> }
>
> On Fri, Jul 1, 2011 at 9:01 AM, NaveenShrivastva
> <[email protected]> wrote:
> >
> >
> > On Fri, Jul 1, 2011 at 5:55 PM, Mark Murphy <[email protected]>
> wrote:
> >>
> >> Use rawQuery() with ? placeholders rather than trying to concatenate
> >> everything yourself. Android and SQLite will properly quote and escape
> >> any strings as necessary.
> >>
> >> On Fri, Jul 1, 2011 at 8:13 AM, NaveenShrivastva
> >> <[email protected]> wrote:
> >> > Sir my sql statement is
> >> > String sql = "insert into tblLocations
> (locType,locUrl,refUuid)
> >> > values ("+
> >> >
> >> >
> map.get("type").toString()+","+map.get("URL").toString()+","+refuuid+")";
> >> >
> >> > getting value from hashmap then inserting .What is mistake hare
> .please
> >> > help
> >> > me
> >> >
> >> >
> >> >
> >> > On Fri, Jul 1, 2011 at 5:40 PM, NaveenShrivastva
> >> > <[email protected]> wrote:
> >> >>
> >> >> Thx sir i am trying
> >> >>
> >> >> On Fri, Jul 1, 2011 at 5:33 PM, Mark Murphy <[email protected]
> >
> >> >> wrote:
> >> >>>
> >> >>> You need to quote your strings, as you do in just about every SQL
> >> >>> database ever invented.
> >> >>>
> >> >>> On Fri, Jul 1, 2011 at 7:56 AM, naveen kumar
> >> >>> <[email protected]> wrote:
> >> >>> > Caused by: android.database.sqlite.SQLiteException: unrecognized
> >> >>> > token: ":": , while compiling: insert into tblShows
> >> >>> > (shIcon,shSummary,shGenres,shName,shType,shUuid,localIcon) values
> >> >>> >
> >> >>> > (
> http://a725.phobos.apple.com/us/r1000/054/Video/e4/50/b7/mzl.qynukdwm.
> >> >>> > 133x100-99.jpg,,Comedy,30 Rock,tv,S00281,show_S00281.png)
> >> >>> >
> >> >>> > --
> >> >>> > You received this message because you are subscribed to the Google
> >> >>> > Groups "Android Developers" group.
> >> >>> > To post to this group, send email to
> >> >>> > [email protected]
> >> >>> > To unsubscribe from this group, send email to
> >> >>> > [email protected]
> >> >>> > For more options, visit this group at
> >> >>> > http://groups.google.com/group/android-developers?hl=en
> >> >>> >
> >> >>>
> >> >>>
> >> >>>
> >> >>> --
> >> >>> Mark Murphy (a Commons Guy)
> >> >>> http://commonsware.com | http://github.com/commonsguy
> >> >>> http://commonsware.com/blog | http://twitter.com/commonsguy
> >> >>>
> >> >>> _Android Programming Tutorials_ Version 3.5 Available!
> >> >>>
> >> >>> --
> >> >>> You received this message because you are subscribed to the Google
> >> >>> Groups "Android Developers" group.
> >> >>> To post to this group, send email to
> >> >>> [email protected]
> >> >>> To unsubscribe from this group, send email to
> >> >>> [email protected]
> >> >>> For more options, visit this group at
> >> >>> http://groups.google.com/group/android-developers?hl=en
> >> >>
> >> >>
> >> >> --
> >> >> Naveen Shrivastava
> >> >> BCA+MCA(LAST SEM)+O/A/B Level(DOEACC SOCITY IT GOVT INDIA)
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> > Naveen Shrivastava
> >> > BCA+MCA(LAST SEM)+O/A/B Level(DOEACC SOCITY IT GOVT INDIA)
> >> >
> >> > --
> >> > You received this message because you are subscribed to the Google
> >> > Groups "Android Developers" group.
> >> > To post to this group, send email to
> [email protected]
> >> > To unsubscribe from this group, send email to
> >> > [email protected]
> >> > For more options, visit this group at
> >> > http://groups.google.com/group/android-developers?hl=en
> >>
> >>
> >>
> >> --
> >> Mark Murphy (a Commons Guy)
> >> http://commonsware.com | http://github.com/commonsguy
> >> http://commonsware.com/blog | http://twitter.com/commonsguy
> >>
> >> _Android Programming Tutorials_ Version 3.5 Available!
> >>
> >> --
> >> You received this message because you are subscribed to the Google
> >> Groups "Android Developers" group.
> >> To post to this group, send email to
> [email protected]
> >> To unsubscribe from this group, send email to
> >> [email protected]
> >> For more options, visit this group at
> >> http://groups.google.com/group/android-developers?hl=en
> >
> > Hello sir,
> >
> > Please refer the link
> >
> >
> http://sagistech.blogspot.com/2010/07/notes-on-android-sqlite-bukl-insert.html
> >
> > This example have only one table column.
> >
> > i want to use many columns for bind
> >
> > db =
> >
> openOrCreateDatabase("dvrAppDb.sqlite",SQLiteDatabase.CREATE_IF_NECESSARY,null);
> >
> > db.beginTransaction();
> >
> > SQLiteStatement insert = null;
> > try {
> > String sql = "insert into tblShows
> > (shIcon,shSummary,shGenres,shName,shType,shUuid,localIcon) values
> > (?,?,?,?,?,?,?)";
> > insert = db.compileStatement(sql);
> >
> > System.out.println("sssssssssssssssssssssssssssssssss======"+sql);
> >
> >
> > for (int i = 0; i < shIconArr.size(); i++) {
> >
> >
> > insert.bindString(i,shIconArr.get(i));
> > insert.bindString(shSummaryArr.get(i));//here facing issue
> for
> > interface
> > ,shGenresArr.get(i),shNameArr.get(i), shTypeArr.get(i),
> > shUuidArr.get(i),shlocalIconArr.get(i) );
> >
> > insert.executeInsert();
> >
> > db.setTransactionSuccessful();
> >
> > }
> > } catch (SQLException e) {
> > // TODO Auto-generated catch block
> > e.printStackTrace();
> > }
> > finally
> > {
> > db.endTransaction();
> > db.close();
> > }
> >
> > Please help me
> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to [email protected]
> > To unsubscribe from this group, send email to
> > [email protected]
> > For more options, visit this group at
> > http://groups.google.com/group/android-developers?hl=en
>
>
>
> --
> Mark Murphy (a Commons Guy)
> http://commonsware.com | http://github.com/commonsguy
> http://commonsware.com/blog | http://twitter.com/commonsguy
>
> _Android Programming Tutorials_ Version 3.5 Available!
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>
i have already done that concept for insert in db but it takes more time.
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
