Using String[] selectionArgs in SQLiteDatabase.query()

android android-sqlite android-cursor
BenjiWiebe picture BenjiWiebe · May 8, 2012 · Viewed 47.2k times · Source

How do I use the String[] selectionArgs in SQLiteDatabase.query()? I wish I could just set it to null, as I have no use for it. I am just trying to load an entire unsorted table from a database into a Cursor. Any suggestions on how to achieve this?

Answer

Gal Ben-Haim picture Gal Ben-Haim · May 9, 2012

selectionArgs replace any question marks in the selection string.

for example:

String[] args = { "first string", "[email protected]" };
Cursor cursor = db.query("TABLE_NAME", null, "name=? AND email=?", args, null);

as for your question - you can use null

Related questions

How can I create a list Array with the cursor data in Android

How can I create a list Array (the list display First Alphabet when scroll) with the cursor data?

Read More
Android SQLite: attempt to re-open an already-closed object

I'm trying to get certain book data from my Inventory table based on the ISBN. However, I'm getting an error: "attempt to re-open an already-closed object". The error only occurs when I click a listView object, go to a different …

Read More
Putting cursor data into an array

Being new in Android, I am having trouble dealing with the following: public String[] getContacts(){ Cursor cursor = getReadableDatabase().rawQuery("SELECT name FROM contacts", null); String [] names = {""}; for(int i = 0; i < cursor.getCount(); i ++){ names[i] = cursor.getString(i); } cursor.…

Read More