UBB.Developers Forums UBB.threads 7 Development How Do I? How do I update multiple Subject lines at once?

If I try to run the following:

UPDATE w3t_Backup SET B_Subject="The Telana" WHERE B_Number='205';

...it works fine. But if I try to bundle them where I update multiple subjects at once:

UPDATE w3t_Backup SET B_Subject="The Telana" WHERE B_Number='205';
UPDATE w3t_Backup SET B_Subject="A Lost Brother" WHERE B_Number='206';
UPDATE w3t_Backup SET B_Subject="Family Reunion" WHERE B_Number='208';

...I am getting SQL Command Errors in the SQL Command Box in the Admin area.

[]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE w3t_Backup SET B_Subject="A Lost Brother" WHERE B_Num row(s) affected by your query. [/]
Do I have something in the wrong spot in that? I have tried single and double quotes around my subject line, nothing has worked so far with multiple UPDATES

" and ' and ` all fail.

Yeah, you can only do 1 UPDATE per query. You might be able to do multiple queries in phpMyAdmin. But I'm not sure if the Threads SQL panel is set up for that.

Oh and - they should all be single quotes. '

K, wasn't sure if that had something to do with it.

What is funny...is my phpMyAdmin is also giving me fits with this. It complains about my quotes...single versus double. Now to figure that one out!

Yea, here is a fun one. Three different versions here, all three error out:

UPDATE w3t_Posts SET B_Subject=`Chess Pieces` WHERE B_Number=218
MySQL said: Unknown column 'Chess Pieces' in 'field list'

UPDATE w3t_Posts SET B_Subject='Chess Pieces' WHERE B_Number=218;
MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Chess Pieces\' WHERE B_Number=218' at line 1

UPDATE w3t_Posts SET B_Subject="Chess Pieces" WHERE B_Number=218;
MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"Chess Pieces" WHERE B_Number=218' at line 1

Are you using the stright up and down quote ' or the slanted single quote in the upper left of your keyboard. ` It should be the straight up and down one.

FYI it was my version of phpMyAdmin...I upgraded just now, ran the same UPDATE file, and it worked fine.

Who woulda thunk!

Wow -that's an odd one. Glad you got it sorted out.