you should pass bathroom with apices, so 'bathroom' not bathroom.
with apices sql knows you are talking about a value not a column name.
String APICE = "'"; //the value is '
sampleDB.execSQL("SELECT RoomID FROM " +ROOM_TABLE_NAME+"where
RoomName="+ APICE + selectedRoom + APICE);
hope i understood the problem.
On Nov 11, 11:45 am, "pramod.deore" <[email protected]> wrote:
> 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
