With MS SQL I used to be able to do something like this:
<cfquery ...> INSERT INTO a ( ... ) VALUES ( ... ); INSERT INTO b ( ... ) VALUES ( ... ); DELETE FROM c; </cfquery>
This doesn't seem to be working for me with MySQL. I'm able to run the queries together in the workbench by separating them with semi-colons, but not when I run them though cfquery, any help from you MySQL/CF programmers would be fantastic!
*PS: I know this looks like a prime example for a stored procedure, but I won't always be able to set those up for our clients.
As Always, Thanks!