I have this table:
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?
Aucun commentaire:
Enregistrer un commentaire