I have a set of db inserts involving two datasources and if there is a failure in the 2nd datasource, I need to roll back the transaction on the first datasource. In a perfect world I could somehow hold up the first transaction commit until the transaction on the second datasource has completed successfully and then commit them both. However I'm not sure how to do this with cftransaction since it throws an error if multiple datasources are used. Doing the transaction in just SQL might be doable, but I would like to avoid that if at all possible, because the amount of re-engineering that would be necessary.
Anyone have a suggestion? -- jon mailto:[EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
