Android: SQLite Cannot bind argument at index because the index is out of range

Question

I'm using an SQLite database to store items. When I call items by their ids using where clause and selection args. If I pass a selection args array with more than one item id, it crashes with error:

Cannot bind argument at index 2 because the index is out of range. The statement has 1 parameters.

Here is how I perform the query:

    override fun onCreateLoader(id: Int, args: Bundle?): Loader<Cursor> { 
    loaderId = id 
    val selectionArgs = arrayOf("2", "1")
    return CursorLoader(activity!!,
            MenuContract.ItemEntry.CONTENT_URI,
            Constants.ITEM_PROJECTION_COLUMNS,           
            MenuContract.ItemEntry._ID + "=?",  
            selectionArgs,
            null
    ) 
}

It works fine if the selectionArgs array contains only one id. Not sure why.

MikeT · Accepted Answer · 2019-02-22 21:21:57Z

1

The number of selection args must match the number of ?'s (placeholders). So the error is basically saying where do I put the second argument as I've already replaced the first ? (placeholder)

It works when there is only 1 array element, because there is only 1 ? (placeholder).

Perhaps you want :-

MenuContract.ItemEntry._ID + "=? OR " + MenuContract.ItemEntry._ID + "=?",

Then both arguments have a placeholder.

edited Feb 22, 2019 at 21:21

answered Feb 22, 2019 at 21:09

MikeT

57.9k16 gold badges61 silver badges78 bronze badges

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

1 Comment

Badr Bujbara Over a year ago

Thank you that worked! In my case the user can add items to favorites, and I'm storing the added items' ids in prefs so when the favorites screen opens, it fetches items based on those ids. Now, I guess, I need to form the selection string based on the number of items. This selection part is not intuitive.

Collectives™ on Stack Overflow

Android: SQLite Cannot bind argument at index because the index is out of range

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related