java - Column Index not finding a column that definitely exists -

try {     cursor c = db.rawquery("select time updatetimes type = 'root'", null);     long time = c.getlong(c.getcolumnindex("time")); } catch (cursorindexoutofboundsexception e) {  } 

this exception gets thrown, though column "time" exists, the same query returns data expected when using sqlite3 client. ideas?

the cursor not @ valid index. need move first:

if (c.movetonext()) {     time = c.getlong(c.getcolumnindex("time")); }