You are correct, it was the paren. However, here is the SQL string that doesn't seem to be operating properly. Yet there are no errors reported.
Code: Select all
UPDATE guest_login SET FIRST_NAME= 'bob2', LAST_NAME= 'newhart', EMAIL_ADDRESS= 'bob@newhart.com', WHAT_U_LIKED= 'yes' AND FIRST_NAME= 'bob3', LAST_NAME= 'newhart', EMAIL_ADDRESS= 'bob2@newhart.com', WHAT_U_LIKED= 'yes2' AND FIRST_NAME= 'bob4', LAST_NAME= 'newhart', EMAIL_ADDRESS= 'bob3@newhart.com', WHAT_U_LIKED= 'yes' WHERE (FIRST_NAME='bob' AND LAST_NAME= 'newhart' AND EMAIL_ADDRESS='bob@newhart.com' AND WHAT_U_LIKED='yes') AND (FIRST_NAME='bob2' AND LAST_NAME= 'newhart' AND EMAIL_ADDRESS='bob2@newhart.com' AND WHAT_U_LIKED='yes2') AND (FIRST_NAME='bob3' AND LAST_NAME= 'newhart' AND EMAIL_ADDRESS='bob3@newhart.com' AND WHAT_U_LIKED='yes')
Why is this not working? I guess I have to retrieve the ID which is the unique identifier to make this work. I can do a single update with no problem but multiple rows updates have yet to be successful, but it seems like such an easy process in theory.
Hopefully the last time but thanks in advance