MySQL Queries with multiple statements

[roadWorkAhead]

I'm trying to include multiple statement in a MySQL query. MySQL seems to
need to have a linefeed between the statements to work correctly but no matter
what text i put in between the cfquery tags, CF passes the query as one long
string to mysql... causing an error.

Any ideas how to make this work?

<cfquery NAME="sqldata" datasource="local">
DELETE * FROM PROJECTS;
INSERT INTO PROJECTS SELECT * FROM PROJECTS_NEW;
</cfquery>

I know i can do this with two separate cf queries...... but i'm trying to
integrate this kind of query with AJAX.... so i'd like to have both sql
statements executed in one call to the server.

[mxstu]

I'm not sure that is the problem. Assuming you're using jdbc, is your
datasource configured to allow multiple sql statements? You may need to enable
that setting.
[url]http://www.petefreitag.com/item/357.cfm[/url]
[url]http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html[/url]