Never mind. I am not sure about cf 7 but on our earlier versions sometimes the rollback would not work unless I did it that way.
Lori -----Original Message----- From: Stone, Mary L CTR NAWCAD, Bldg 447 [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 15:01 To: CF-Talk Subject: RE: cftry and transactions try this: <cfcatch type="any"> <cftransaction action="rollback" /> <cfset returnObj["message"] = cfcatch.Message & ": " & cfcatch.Detail /> <cfset blnOk = false> //of course set this to true outside cfcatch first </cfcatch> <cfif blnOk> <cftransaction action="commit" /> </cfif> </cftransaction> </cftry> Lori -----Original Message----- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 14:50 To: CF-Talk Subject: cftry and transactions Hi folks Can anyone tell me what is wrong with the following code? It is a snippet of code from a cfc I am working on. The problem I am having if that if one of the queries inside the loop fails for whatever reason (ie, db constraint error), the previous inserts are not removed from the db. Shouldn't the rollback in the cfcatch take care of that for me? Thanks <cftry> <cftransaction action="begin" /> <cfstoredproc procedure="addSequence" datasource="sis"> <cfprocparam value="#arguments.seqName#" cfsqltype="cf_sql_varchar" type="in" /> <cfprocparam type="out" cfsqltype="cf_sql_bigint" variable="sequenceID" /> </cfstoredproc> <cfloop from="1" to=#arrayLen(seqArray)# index="index"> <cfquery name="addSequence" datasource="sis"> insert into sequenceLookup (sequenceID, examID, placeInOrder) values ( <cfqueryparam value="#sequenceID#" cfsqltype="cf_sql_bigint" />, <cfqueryparam value="#seqArray[index][1]#" cfsqltype="cf_sql_bigint" />, <cfqueryparam value="#seqArray[index][2]#" cfsqltype="cf_sql_bigint" /> ) </cfquery> </cfloop> <cfset returnObj["status"] = true /> <cfset returnObj["message"] = "Sequence Added." /> <cftransaction action="commit" /> <cfcatch type="any"> <cftransaction action="rollback" /> <cfset returnObj["message"] = cfcatch.Message & ": " & cfcatch.Detail /> </cfcatch> </cftry> --- --- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
