Or should you just have 1 try:
<cftransaction>
<cftry>
<cfquery 1>
<cfquery 2>
....
<cfcatch>
Error handling with catch message indicating where problem was.
</cfcatch>
</cftry>
If error rollback, otherwise commit
</cftransaction>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:34 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...
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
