> Here is the outline of the code that should work. Just > plug in your queries: > > ... CFTRANSACTION with nested CFTRYs snipped ...
Yikes! You don't need to use exception handling to rollback the transaction - that's what CFTRANSACTION itself is for! If you have three queries in a CFTRANSACTION, and any of them fail, they'll all be rolled back, as long as all queries use the same database connection information (datasource, username, password). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
