I am getting following exception during a database query wenn the
table is empty and orderBy is not null (either modified ASC or
modified DESC).
Is something is wrong hier?
---
logcat output
android.database.sqlite.SQLiteException: no such column:
modified: ,
while compiling: SELECT _id, name FROM client ORDER BY modified ASC
---
this code causes exception:
SQLiteDatabase db = mOpenHelper.getReadableDatabase();
Cursor c = qb.query(db, projection, selection, selectionArgs,
null, null, orderBy);
this code works:
SQLiteDatabase db = mOpenHelper.getWritableDatabase();
Cursor c = qb.query(db, projection, selection, selectionArgs,
null, null, null);
+++
--~--~---------~--~----~------------~-------~--~----~
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]
Announcing the new Android 0.9 SDK beta!
http://android-developers.blogspot.com/2008/08/announcing-beta-release-of-android-sdk.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---