Hi Everyone,
I have a table and I want to retrieve one column (RoomName) from this
table and display it as a list. had tried it but it gives me
exception as " java.lang.IllegalArgumentException: column '_id' does
not exist"
My .java class is
public class RemoveRoom extends Activity
{
SQLiteDatabase sampleDB = null;
String SAMPLE_DBNAME = "HomeAutoDataBase";
String ROOM_TABLE_NAME = "RoomTable";
String SWITCH_TABLE_NAME = "SwitchTable";
protected ListAdapter adapter;
protected ListView roomList;
@Override
public void onCreate(Bundle savedInstanceState)
{
System.out.println ("First statement in RemoveRoom");
super.onCreate(savedInstanceState);
setContentView(R.layout.roomlist);
roomList = (ListView) findViewById (R.id.list);
displayRoomList();
}
public void displayRoomList()
{
try
{
sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME,
MODE_PRIVATE, null);
Cursor c = sampleDB.rawQuery("SELECT RoomName 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[] {"RoomName"},
new int[] {R.id.roomname}); //here I got
exception
roomList.setAdapter(adapter);
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
my .xml file is
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/
android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent">
<ListView
android:id="@+id/list"
android:layout_width="fill_parent"
android:layout_height="fill_parent"/>
<TextView
android:id="@+id/roomname"
android:layout_width="wrap_content"
android:layout_height="wrap_content"/>
</LinearLayout>
And my logcat gives me
12-03 10:48:03.540: WARN/System.err(573):
java.lang.IllegalArgumentException: column '_id' does not exist
12-03 10:48:03.560: WARN/System.err(573): at
android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:
314)
12-03 10:48:03.570: WARN/System.err(573): at
android.widget.CursorAdapter.init(CursorAdapter.java:111)
12-03 10:48:03.580: WARN/System.err(573): at
android.widget.CursorAdapter.<init>(CursorAdapter.java:90)
12-03 10:48:03.589: WARN/System.err(573): at
android.widget.ResourceCursorAdapter.<init>(ResourceCursorAdapter.java:
47)
12-03 10:48:03.600: WARN/System.err(573): at
android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:88)
12-03 10:48:03.611: WARN/System.err(573): at
com.monarch.home.RemoveRoom.displayRoomList(RemoveRoom.java:47)
12-03 10:48:03.640: WARN/System.err(573): at
com.monarch.home.RemoveRoom.onCreate(RemoveRoom.java:29)
12-03 10:48:03.651: WARN/System.err(573): at
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:
1047)
12-03 10:48:03.660: WARN/System.err(573): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
2459)
12-03 10:48:03.669: WARN/System.err(573): at
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:
2512)
12-03 10:48:03.679: WARN/System.err(573): at
android.app.ActivityThread.access$2200(ActivityThread.java:119)
12-03 10:48:03.700: WARN/System.err(573): at
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
12-03 10:48:03.710: WARN/System.err(573): at
android.os.Handler.dispatchMessage(Handler.java:99)
12-03 10:48:03.710: WARN/System.err(573): at
android.os.Looper.loop(Looper.java:123)
12-03 10:48:03.720: WARN/System.err(573): at
android.app.ActivityThread.main(ActivityThread.java:4363)
12-03 10:48:03.730: WARN/System.err(573): at
java.lang.reflect.Method.invokeNative(Native Method)
12-03 10:48:03.750: WARN/System.err(573): at
java.lang.reflect.Method.invoke(Method.java:521)
12-03 10:48:03.770: WARN/System.err(573): at
com.android.internal.os.ZygoteInit
$MethodAndArgsCaller.run(ZygoteInit.java:860)
12-03 10:48:03.781: WARN/System.err(573): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
12-03 10:48:03.790: WARN/System.err(573): at
dalvik.system.NativeStart.main(Native Method)
--
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
