>MySQL doesn't allow multiple statements in a single query unless you >change a server config option. It's a form of SQL injection >protection. So just run the two statements in two CFQUERY tags. >You'll need to ensure they're on the same connection with no >interleaved queries though, so make sure you use CFTRANSACTION if, for >some reason, you're not already.
Thanks barney! That got me headed down the right path. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4