dimanche 4 janvier 2015

sqlite selection returns no results

I have this table:


enter image description here


and I try to select phone = 9 and isBlocked = 1


SQLiteDirectCursorDriver: SELECT KEY_ID FROM BLOCKED_PHONES_TABLE WHERE KEY_PHONE = ? AND KEY_IS_BLOCKED = ?


code:



Cursor cursor = this.getReadableDatabase().query(
BLOCKED_PHONES_TABLE,
new String[] { KEY_ID }, KEY_PHONE+" = ? AND "+KEY_IS_BLOCKED+" = ?",
new String[] { phone, "1" }, null, null, null);

while(cursor.moveToNext()) {
result = new Phone();
result.id = (cursor.getInt(0));
result.phone = phone;
result.isBlocked = true;
}
return result;
}


but I get empty results set.


what do i need to fix?


enter image description here


Aucun commentaire:

Enregistrer un commentaire