Hello all. Question regarding cftransaction and commit action. <cftransaction> <cftry> <cfloop file>
<cfquery insert> <cfquery update> </cfloop> <cfcatch>generate error message</cfcatch> </cftry> <cfif error message is null or override commit=1> <cftransaction commit> <cfelse> <cftransaction rollback> button to allow a forced commit (which should, because of the try catch, only commit those rows which are successful queries). </cftransaction> The question: I'm in the cftransaction commit but it's not committing... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm