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] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
