mercredi 16 décembre 2015

How to pass two or more selection argument in query method android studio sqlite

I am new to Android Studio and android development, I'm having problems passing in multiple parameters into sqlite using a cursor I have the following:

Cursor cursor = DB.rawQuery("select _id, BookingType as bookingType from " + table + " where " + SqLiteTableData.TableStructure.KEY_BOOKING_DATE+" = ?  AND  " + SqLiteTableData.TableStructure.KEY_BOOKING_TIME+ " = ? " , new String[]{a, b });

which in the debugger displays the following:

SQLiteDirectCursorDriver: select _id, BookingType as bookingType from Bookings where BookingDate = ?  AND  BookingTime = ?

The parameters are not been passed

I have spent ages on this and looked at other posts such as How to pass two or more selection argument in "query" method

android sqlite query with multiple where

But cannot get it to work

Any help appreciated

Aucun commentaire:

Enregistrer un commentaire