How do you format Update statement with multiple conditions

[hammer]

Below shows a workableUpdate format for changing 1 field with 1 Where condition. I understand how the Bobby Table Format association works here.
What would the Format look like with multiple field changes and multiple conditions?

def update_cowTbl(self,tagNoC,tagClrC,tagYrC,tagNoV,tagClrV,tagYrV):
self.c.execute("UPDATE cowTbl SET tagNo=? WHERE tagNo=?",(tagNoV,tagNoC))
self.con.commit()

What does not work: ("UPDATE cowTbl SET tagNo=?,tagClr=? WHERE tagNo=?,tagClr=?",(tagNoV,tagNoC),(tagClrV,tagClrC))

Larz60+ write Dec-16-2021, 04:42 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

Please use bbcode tags, it's a forum rule.

[ibreeden]

What does not work: ("UPDATE cowTbl SET tagNo=?,tagClr=? WHERE tagNo=?,tagClr=?",(tagNoV,tagNoC),(tagClrV,tagClrC))

There should be one tuple, and multiple "where" conditions should be separated by "and" or "or". So:

"UPDATE cowTbl SET tagNo=?, tagClr=? WHERE tagNo=? AND tagClr=?",(tagNoV, tagNoC, tagClrV, tagClrC)

[hammer]

Thank you.
I made just one tuple and i added the "and"' for separating the conditions as you suggested. It does not error-out like before but I can not seem to get the items in the tuple sequenced correctly to return what needs to be updated. Could you go a little bit further with what in the tuple matches up with what in the SET and WHERE using below-ie val1-?1, val2-?4 etc?

"UPDATE cowTbl SET A=?1, B=?2, C=?3 Where X=?4 and X=?5" ,(val1, val2, val3,val4,val5)

[ibreeden]

Could you go a little bit further with what in the tuple matches up with what in the SET and WHERE using below-ie val1-?1, val2-?4 etc?

The values in the SQL statement are filled in in the same order as they appear in the tuple.
So A=val1, B=val2, C=val3, X=val4, X=val5.

[hammer]

Worked Perfect, problem resolved. Sorry for not using BBCode.
Thanks