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 <[email protected]> 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 <[email protected]> > > > 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" <[email protected]> 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 [email protected] > > To unsubscribe from this group, send email to > > [email protected]<android-developers%[email protected]> > > 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 [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
