Reputation: 2996
I have this code:
if (idListe.size()>0)
{
strIdArray = new String[idListe.size()];
idListe.toArray(strIdArray);
//my query starts here
c = dbHelper.query(true, DataBaseHelper.DB_COURSE,
dbHelper.COURSE_TABLE_AUFGABEN, new String[] {
dbHelper.COURSE_AUFGABEN_COLUMN_ID,
dbHelper.COURSE_AUFGABEN_COLUMN_ADRESSID,
dbHelper.COURSE_AUFGABEN_COLUMN_KURSART }, dbHelper.COURSE_AUFGABEN_COLUMN_ID + " = ?",strIdArray,
dbHelper.COURSE_AUFGABEN_COLUMN_KURSART, null,
dbHelper.COURSE_AUFGABEN_COLUMN_KURSART + " ASC", null);
startManagingCursor(c);
}
And get a this error:
01-15 13:01:27.489: E/AndroidRuntime(703): android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x3fd490
I've tried several combinations and the result always stays the same. If the size of the strIdArray is '1' the query works. What am I doing wrong here?
Upvotes: 0
Views: 1456
Reputation: 6892
If the size of the strIdArray is '1' the query works. What am I doing wrong here?
You're only having one ? while you provide several parameters when the size of strIdArray is bigger than one.
Upvotes: 1
Reputation: 1214
This code fragment does not explain too much, since it uses some (German) 3rd party library and it hides the actual query.
However you can try this solution if is relevant.
It would be easier to help if you could provide more details about the actual query.
Upvotes: 0