Monday, 26 August 2013

SQLite query not `ORDER BY` correctly

SQLite query not `ORDER BY` correctly

Here is my code:
// Get all gas fillup values in database
List<Gas> values = datasource.getAllGas();
Then
public List<Gas> getAllGas() {
List<Gas> gases = new ArrayList<Gas>();
Cursor cursor = database.query(MySQLiteHelper.TABLE_GAS, allColumns,
null, null, null, null, MySQLiteHelper.COLUMN_ID + " DESC");
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
Gas gas = cursorToGas(cursor);
gases.add(gas);
cursor.moveToNext();
}
cursor.close();
return gases;
}
As you see, I am ordering by " DESC"; though it continually orders as if I
put null here instead.

No comments:

Post a Comment