@ Barney: you CAN run multiple queries in one <cfquery> tag as long as you db supports it. by default, mysql db does not, but one can easily change that using mysql admin or another mysql db administration tool...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Barney Boisvert wrote: > It doesn't work because you can't run multiple statements in a single > query. If you use two CFQUERY tags (wrapped in a CFTRANSACTION to > ensure connection affinity) it'll work fine. MySQL Front is splitting > the single query into two distinct queries on the semicolon, sending > each to the server independently, and then giving you back the two > results. I.e. it's a client-side optimization, not server > functionality. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
