Android SQLite column index

Question

I am quering to my SQLite data base to get records using IN operator

myDataBase.rawQuery("SELECT * FROM artist WHERE artist_id IN (?)", values);

but i am getting some SQLite exception. i did not understand what the problem is when my database has 1 record which was returned by this query then it was prefect, but when i have 2 or more records in my database to return by this query it is throwing some exception that exception is

SQLiteException: bind or column index out of range

please let me know what i am doing wrong with this query

thanks...

you have to have a separate '?' for each value in `values` array. see http://stackoverflow.com/questions/7418849/android-sqlite-in-clause-and-placeholders — David M, Feb 08 '13 at 14:06

Yaroslav Mytkalyk · Accepted Answer · 2013-02-08T14:18:25.053

1

I would suggest like this

StringBuilder query = new StringBuilder();
// build "SELECT * FROM artist WHERE artist_id IN "
query.append('(').
for (int i = 0; i < values.length; i++) {
    query.append(values[i]);
    if (i != values.length - 1) {
        query.append(',');
    }
}
query.append(')');

myDataBase.rawQuery(query.toString(), null);

edited Feb 08 '13 at 14:18

answered Feb 08 '13 at 14:09

Yaroslav Mytkalyk

16,950
10
72
99

Thanks man i have tried the same approach to solve this issue :) – Farrukh Feb 08 '13 at 14:23

Android SQLite column index

1 Answers1