vendredi 6 mars 2015

How to use AND operator in update operation for where clause in Android Sqlite?

I am trying to update my table, But It gives me error how can I use AND operator in Where clause for update?


here is my code;



public static void updateData(long lday, String id, String usedamount, String trashedamount) {
// TODO Auto-generated method stub
ContentValues updatedValues = new ContentValues();

updatedValues.put("usedamount", usedamount);
updatedValues.put("trashedamount",trashedamount);

// HERE I WANT TO USE AND OPERATOR FOR DAY AND ID
// this and operator gives error


db.update("info_table", updatedValues, DAY + "=" + lday AND ID + "=" + id, null);

}


Can anyone help me?


Aucun commentaire:

Enregistrer un commentaire