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

Question

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?

it does not update this code db.update("info_table", updatedValues, DAY + "=" + lday AND ID + "=" + id, null); — Ert
– Ert, Commented Mar 6, 2015 at 9:59
Edit your question and add the exact error message you receive. — Inspector Squirrel
– Inspector Squirrel, Commented Mar 6, 2015 at 10:00
i mean what exception you are getting here? share the exception — Fahim
– Fahim, Commented Mar 6, 2015 at 10:00
it says Multiple markers at this line - The primitive type long of lday does not have a field ID — Ert
– Ert, Commented Mar 6, 2015 at 10:00

the-ginger-geek · Accepted Answer · 2015-03-06 10:01:22Z

0

Your AND operator needs to be in quotation marks

public static void updateData(long lday, String id, String usedamount, String trashedamount) {
    ContentValues updatedValues = new ContentValues();          
    updatedValues.put("usedamount", usedamount);
    updatedValues.put("trashedamount",trashedamount);

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

answered Mar 6, 2015 at 10:01

the-ginger-geek

7,0914 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ert Over a year ago

yes it is fine but it needs 9 minutes to accept the answer :) thanks a lot.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related