now, if I want to know which of my queries failed and what error message the DB returned for that errant query, I will need the multiple try/catches within the transaction.
Doug >-----Original Message----- >From: Dave Watts [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 11, 2003 2:55 PM >To: CF-Talk >Subject: RE: cftransaction HELP Please... > > >> 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
