sree_iphonedev sree_iphonedev - 1 year ago 121
Android Question

rawQuery(query, selectionArgs)

I want to use select query for retrieving data from table. I have found, rawQuery(query, selectionArgs) method of SQLiteDatabase class to retrieve data. But I don't know how the "query" and "selectionArgs" should be passed to rawQuery method?

Answer Source
rawQuery("SELECT id, name FROM people WHERE name = ? AND id = ?", new String[] {"David", "2"});

You pass a string array with an equal number of elements as you have "?"

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download