CODEWITHSUNDEEP
javaandroidsqliteandroid-sqlite
Danila says Reinstate Monica
Danila says Reinstate Monica

Reputation: 161

SQLite Android multiple selectionArgs for one selection parametr

I now there are similar questions here, but I can't figure out what to do by them, I got following code

 Cursor getterCursor = null;

    String selection = "topic" + " =? ";
    String[] selectionArgs = new String[] {"topic1", "topic2"};

    getterCursor = questionsDatabase.query(mDBName, null, selection, selectionArgs, null, null, null);

And it returns an error java.lang.IllegalArgumentException: Cannot bind argument at index 2 because the index is out of range. The statement has 1 parameters.. I understand that it happens because I got two elements in array selectionArgs, but I have completely no idea how to make it work right, help please. One more time: I really tried to solve it by myself following the guides from internet and from SO in particular, but I could not handle it, so now asking for help here. Thanks in advance!

Upvotes: 2

Views: 394

Answers (1)

forpas
forpas

Reputation: 164099

If you want results for 2 vaues of topic then use the operator IN:

String selection = "topic IN (?, ?)";

This is equivalent to:

String selection = "topic = ? OR topic = ?";

Upvotes: 3

Related Questions