Just a note that the CFTRANSACTION needs to be around the entire block of CFQUERY statements, or else it does you no good ...
<cftransaction> <cftry> <cfquery> DELETE some stuff </cfquery> <cfquery> INSERT some stuff </cfquery> <cfquery> UPDATE some other stuff </cfquery> <cfcatch type="Database"> trap your error and report back to yourself </cfcatch> </cftry> </cftransaction> That will make sure that any error on the DB side gets caught and reported, but all changes get reset to where they were before the first query ever started. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
