Dave, So with CFTransaction, the only reason to use <CFTRY> is if you want additional error handling? For example, if I want details every time this fails, I could use try within a transaction to capture failure reason? Is there a better way?
Do you normally attempt to capture the reason that a transaction fails? Andy -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 1: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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4