You may just need to close the tag <cftransaction commit />
you are also missing a </cfif> On Fri, Mar 25, 2011 at 3:25 PM, ike Savino <[email protected]> wrote: > > 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:343277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
