According to Mastering ColdFusion 5: "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".
Not what you want to hear I'm sure, but sounds like it can't be done the way you want. 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 second one, or using cftry/cfcatch, or a combination of the 2? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4