jeudi 11 juin 2015

Getting All data from specific column in SQLITE Android

There is android sqlite database with one table, im using this query for getting values :

        Cursor cursor = db.query(Table_Items, null, "type=? AND operationtype=? AND problemtype=?",
            new String[] { roosazi,type,problem }, null, null,KEY_Items_ID+" "+date , null);

everything is working fine. question is: how can i get all from specific column? let me give an example: all values with type="A" and operationtype="XYZ" are needed , no matter what problemtype is! of course i can use something like this :

        Cursor cursor = db.query(Table_Items, null, "type=? AND operationtype=?",
            new String[] { roosazi,type }, null, null,KEY_Items_ID+" "+date , null);

but problem is sometimes problemtype is X and sometimes its like ALL!

how can i achieve this? can i put something like * instead of problem?

thank u so much

Aucun commentaire:

Enregistrer un commentaire