Dec-16-2021, 02:50 PM
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)
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)
