Yeah, that's actually what I am doing, if the first fails, no need to do the second one at all. The problem lies in that when the second query fails, I need to roll back the first.
-- jon mailto:[EMAIL PROTECTED] Thursday, January 9, 2003, 3:27:33 PM, you wrote: MA> According to Mastering ColdFusion 5: MA> "Within a transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to one database before writing a query to another database". MA> Not what you want to hear I'm sure, but sounds like it can't be done the way you want. MA> As a possible wordaround (this is just a shot in the dark and might not be possible), maybe either setting some variable on success of the first query and using a cfif to decide whether to do the MA> second one, or using cftry/cfcatch, or a combination of the 2? MA> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4