sqlite Android - how to get value of specific col /row

Question

I have a method that i pass an id to and then want to find the row in that table that matches the id, and returns a string that is the colLabel of that row:

public String getIconLabel(int id){ String label; String selectQuery = "SELECT "+colL" FROM " + allIcons + " WHERE " +colIconID + "="+id; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); label = //HELP return label; }

I am unclear as to how to set label to be that specific column of the selected row?

please help

jsmith · Accepted Answer · 2012-03-08 16:12:21Z

8

if (null != cursor && cursor.moveToFirst()) { label = cursor.getString(cursor.getColumnIndex(COLUMN_ID)); }

answered Mar 8, 2012 at 16:12

jsmith

4,8972 gold badges35 silver badges39 bronze badges

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

Comments

kosa · Accepted Answer · 2012-03-08 16:12:58Z

if(cursor != null) { cursor.moveToFirst(); String label = cursor.getString(0); }

0 parameter represents your column index. Refer this link.

Collectives™ on Stack Overflow

sqlite Android - how to get value of specific col /row

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related