If I want to read one column from table and display these values (RoomName)on list then how to do this? if that table doesn't have _id field.
should I read the RoomName of each row and store them into array. and then using arrayAdapter display the list? On Dec 3, 1:04 pm, "pramod.deore" <[email protected]> wrote: > When I tried this as > > try > { > sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, > MODE_PRIVATE, null); > Cursor c = sampleDB.rawQuery("SELECT RoomID as _id > FROM " > +ROOM_TABLE_NAME, null); > System.out.println ("Total number of rooms > are"+c.getCount()); > > adapter = new SimpleCursorAdapter( > this, > R.layout.roomlist, > c, > new String[] {"RoomID"}, > new int[] {R.id.roomname}); > roomList.setAdapter(adapter); > > } > catch (Exception e) > { > e.printStackTrace(); > } > > then it throws following exception > > 12-03 13:32:25.331: INFO/System.out(902): Total number of rooms are1 > 12-03 13:32:25.340: WARN/System.err(902): > java.lang.IllegalArgumentException: column 'RoomID' does not exist > 12-03 13:32:25.370: WARN/System.err(902): at > android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java: > 314) > 12-03 13:32:25.370: WARN/System.err(902): at > android.widget.SimpleCursorAdapter.findColumns(SimpleCursorAdapter.java: > 339) > 12-03 13:32:25.389: WARN/System.err(902): at > android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:91) > 12-03 13:32:25.400: WARN/System.err(902): at > com.monarch.home.RemoveRoom.displayRoomList(RemoveRoom.java:47) > 12-03 13:32:25.414: WARN/System.err(902): at > com.monarch.home.RemoveRoom.onCreate(RemoveRoom.java:29) > 12-03 13:32:25.451: WARN/System.err(902): at > android.app.Instrumentation.callActivityOnCreate(Instrumentation.java: > 1047) > 12-03 13:32:25.451: WARN/System.err(902): at > android.app.ActivityThread.performLaunchActivity(ActivityThread.java: > 2459) > 12-03 13:32:25.470: WARN/System.err(902): at > android.app.ActivityThread.handleLaunchActivity(ActivityThread.java: > 2512) > 12-03 13:32:25.492: WARN/System.err(902): at > android.app.ActivityThread.access$2200(ActivityThread.java:119) > 12-03 13:32:25.519: WARN/System.err(902): at > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863) > 12-03 13:32:25.519: WARN/System.err(902): at > android.os.Handler.dispatchMessage(Handler.java:99) > 12-03 13:32:25.531: WARN/System.err(902): at > android.os.Looper.loop(Looper.java:123) > 12-03 13:32:25.550: WARN/System.err(902): at > android.app.ActivityThread.main(ActivityThread.java:4363) > 12-03 13:32:25.550: WARN/System.err(902): at > java.lang.reflect.Method.invokeNative(Native Method) > 12-03 13:32:25.550: WARN/System.err(902): at > java.lang.reflect.Method.invoke(Method.java:521) > 12-03 13:32:25.560: WARN/System.err(902): at > com.android.internal.os.ZygoteInit > $MethodAndArgsCaller.run(ZygoteInit.java:860) > 12-03 13:32:25.560: WARN/System.err(902): at > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618) > 12-03 13:32:25.570: WARN/System.err(902): at > dalvik.system.NativeStart.main(Native Method) > > On Dec 3, 12:51 pm, "Jonas Petersson" <[email protected]> wrote: > > > Um, you might try something like "select RoomID as _id ..." > > > Best / Jonas > > > On 12/03/2010 08:40 AM, Kumar Bibek wrote: > > > > You cannot in this case. This is a mandatory requirement. > > > > "pramod.deore"<[email protected]> wrote: > > > >> Hi Bibek, Thanks for reply. But my table RoomTable have only three > > >> columns, RoomID, RoomName, and RoomSuffix. It doesn't have _id field. > > >> Then how to use Cursor Adapter here. > > > >> On Dec 3, 11:55 am, Kumar Bibek<[email protected]> wrote: > > >>> Cursor Adapters require the table to have a _id field. Else, you would > > >>> get > > >>> this exception. > > >>> Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.com > > -- 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
