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?
If the size of the strIdArray is '1' the query works. What am I doing
ReplyDeletewrong here?
You're only having one ? while you provide several parameters when the size of strIdArray is bigger than one.
This code fragment does not explain too much, since it uses some (German) 3rd party library and it hides the actual query.
ReplyDeleteHowever you can try this solution if is relevant.
It would be easier to help if you could provide more details about the actual query.