RE: cftransaction inside or outside cfloops?

this in mind if the loop is going to be more than just a few records. I always try and put the cftransaction around the least amount of code possible, for this very reason. _ From: Steve Nelson [mailto:[EMAIL PROTECTED] Sent: 10 June 2004 19:16 To: CF-Talk Subject: cftransaction inside or outside

Re: cftransaction inside or outside cfloops?

Wouldn't the answer to this be akin to the standard advice of putting cfoutputs *outside* of a cfloop?In the given example, there is nothing meaningful going on in the loop other than stuff that needs a cftransaction applied to it.Wouldn't applying and reapplying such a block repeatedly be

RE: cftransaction inside or outside cfloops?

. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:37 AM To: CF-Talk Subject: Re: cftransaction inside or outside cfloops? Wouldn't the answer to this be akin to the standard advice of putting cfoutputs *outside

cftransaction inside or outside cfloops?

Which is better and why? cfloop query=whatever cftransaction cfqueryinsert/cfquery cfqueryinsert/cfquery cfqueryinsert/cfquery /cftransaction /cfloop Vs. cftransaction cfloop query=whatever cfqueryinsert/cfquery cfqueryinsert/cfquery cfqueryinsert/cfquery

RE: cftransaction inside or outside cfloops?

: Steve Nelson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 11:16 AM To: CF-Talk Subject: cftransaction inside or outside cfloops? Which is better and why? cfloop query=whatever cftransaction cfqueryinsert/cfquery cfqueryinsert/cfquery cfqueryinsert

RE: cftransaction inside or outside cfloops?

placing an order is the atomic action in the first case, you wrap everything in the transaction tag. HTH, sorry sloppy pseudocode. -Dov _ From: Steve Nelson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 2:16 PM To: CF-Talk Subject: cftransaction inside or outside cfloops? Which

RE: cftransaction inside or outside cfloops?

Subject: cftransaction inside or outside cfloops? Which is better and why? cfloop query=whatever cftransaction cfqueryinsert/cfquery cfqueryinsert/cfquery cfqueryinsert/cfquery /cftransaction /cfloop Vs. cftransaction cfloop query=whatever cfqueryinsert/cfquery cfqueryinsert