[android-developers] Re: select query problem.

Hi, Daniel and Filip Thanks for reply.
after changing query as
sampleDB.execSQL("SELECT RoomID FROM " +ROOM_TABLE_NAME+" where
RoomName='"+selectedRoom + "'");

Now logcat gives following warning

11-11 16:44:42.298: WARN/System.err(772):
android.database.sqlite.SQLiteException: unknown error: Queries cannot
be performed using execSQL(), use query() instead.
11-11 16:44:42.298: WARN/System.err(772): at
android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
11-11 16:44:42.427: WARN/System.err(772): at
android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:
1610)
11-11 16:44:42.427: WARN/System.err(772): at
com.monarch.home.AddRoom.onActivityResult(AddRoom.java:352)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.Activity.dispatchActivityResult(Activity.java:3828)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.ActivityThread.deliverResults(ActivityThread.java:3325)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.ActivityThread.handleSendResult(ActivityThread.java:3371)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.ActivityThread.access$2700(ActivityThread.java:119)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1893)
11-11 16:44:42.427: WARN/System.err(772): at
android.os.Handler.dispatchMessage(Handler.java:99)
11-11 16:44:42.427: WARN/System.err(772): at
android.os.Looper.loop(Looper.java:123)
11-11 16:44:42.427: WARN/System.err(772): at
android.app.ActivityThread.main(ActivityThread.java:4363)
11-11 16:44:42.427: WARN/System.err(772): at
java.lang.reflect.Method.invokeNative(Native Method)
11-11 16:44:42.427: WARN/System.err(772): at
java.lang.reflect.Method.invoke(Method.java:521)
11-11 16:44:42.427: WARN/System.err(772): at
com.android.internal.os.ZygoteInit
$MethodAndArgsCaller.run(ZygoteInit.java:860)
11-11 16:44:42.427: WARN/System.err(772): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
11-11 16:44:42.555: WARN/System.err(772): at
dalvik.system.NativeStart.main(Native Method)
11-11 16:44:48.237: DEBUG/dalvikvm(217): GC freed 43 objects / 1968
bytes in 217ms

On Nov 11, 4:01 pm, Filip Havlicek <havlicek.fi...@gmail.com> wrote:
> Hi Pramod,
>
> since you are trying to select something based on a string where clause, you
> have to encapsulate the string into '', so you have to write either
>  selectedRoom='BathRoom' or sampleDB.execSQL("SELECT RoomID FROM "
> +ROOM_TABLE_NAME+"where
> RoomName='"+selectedRoom+"'"); (= put the quotes inside the select, which is
> imho better).
>
> Best regards,
> Filip Havlicek
>
> 2010/11/11 pramod.deore <deore.pramo...@gmail.com>
>
> > Logcat gives me following output
>
> > 11-11 16:13:13.031: ERROR/Database(709): Failure 1 (no such column:
> > BathRoom) on 0x145618 when preparing 'SELECT RoomID FROM roomtable
> > where RoomName=BathRoom'.
> > 11-11 16:13:13.159: WARN/System.err(709):
> > android.database.sqlite.SQLiteException: no such column: BathRoom:
> > SELECT RoomID FROM roomtable where RoomName=BathRoom
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:
> > 1610)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > com.monarch.home.AddRoom.onActivityResult(AddRoom.java:349)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.Activity.dispatchActivityResult(Activity.java:3828)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.ActivityThread.deliverResults(ActivityThread.java:3325)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.ActivityThread.handleSendResult(ActivityThread.java:3371)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.ActivityThread.access$2700(ActivityThread.java:119)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1893)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.os.Handler.dispatchMessage(Handler.java:99)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.os.Looper.loop(Looper.java:123)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > android.app.ActivityThread.main(ActivityThread.java:4363)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > java.lang.reflect.Method.invokeNative(Native Method)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > java.lang.reflect.Method.invoke(Method.java:521)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > com.android.internal.os.ZygoteInit
> > $MethodAndArgsCaller.run(ZygoteInit.java:860)
> > 11-11 16:13:13.159: WARN/System.err(709):     at
> > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
> > 11-11 16:13:13.286: WARN/System.err(709):     at
> > dalvik.system.NativeStart.main(Native Method)
>
> > On Nov 11, 11:50 am, "pramod.deore" <deore.pramo...@gmail.com> wrote:
> > > Hi ,
>
> > > I have a table in that there is 2 columns. Now I want to retrieve the
> > > value of one column using value of second column (Means suppose my
> > > table name is roomtable. and it contains 2 columns as RoomID and
> > > RoomName)
>
> > >     Now I know value of RoomName and I want to find out value of
> > > RoomID. How to this?
> > > I had tried using following but not succeed.
>
> > > final String ROOM_TABLE_NAME = "roomtable";
> > > sampleDB =  this.openOrCreateDatabase(SAMPLE_DBNAME, MODE_PRIVATE,
> > > null);
>
> > > sampleDB.execSQL("SELECT RoomID FROM " +ROOM_TABLE_NAME+"where
> > > RoomName="+selectedRoom);
>
> > > how to execute this query so I can get RoomID?
> > > Thanks
>
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Android Developers" group.
> > To post to this group, send email to android-developers@googlegroups.com
> > To unsubscribe from this group, send email to
> > android-developers+unsubscribe@googlegroups.com<android-developers%2Bunsubscribe@googlegroups.com>
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en
>
>

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en