> We do it like this: > > <cftransaction action="begin" isolation="serializable"> > <cftry> > > <!--- [mjh] Query here: ---> > <cfquery> > ... > </cfquery> > > <cftransaction action="commit" /> > > <cfcatch> > <cftransaction action="rollback" /> > <cfdump var="#cfcatch#"> > <cfabort> > </cfcatch> > </cftry> > </cftransaction>
There's no need to use CFTRY within CFTRANSACTION like this. If any query fails within the transaction, all other queries will be rolled back. If no query fails, the transaction will be committed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4