android how to get sqlite data by column name

Question

Is it possible to get column data by column name instead of index in sqlite? I don't want to rely on a specific order of the columns. If so, what's the syntax?

user802421 · Accepted Answer · 2012-11-08 22:13:19Z

11

You probably want to use Cursor.getColumnIndex() method.

Returns the zero-based index for the given column name, or -1 if the column doesn't exist. If you expect the column to exist use getColumnIndexOrThrow(String) instead, which will make the error more clear.

Example:

String[] columns = new String[]{ COLUMN_XML };
Cursor c = db.query(TABLE, columns, where, whereArgs, null, null, null);
String xml = c.getString(c.getColumnIndex(COLUMN_XML));

answered Nov 8, 2012 at 22:13

user802421

7,5055 gold badges42 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roy Hinkley Over a year ago

Thanks. Just needed to think about it differently and nest your solution.

Collectives™ on Stack Overflow

android how to get sqlite data by column name

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related