cftransaction inside or outside cfloops?

[Steve Nelson]

Which is better and why?

<cfloop query="whatever">

            <cftransaction>

                        <cfquery>insert....</cfquery>

                        <cfquery>insert....</cfquery>

                        <cfquery>insert....</cfquery>

            </cftransaction>

</cfloop>

Vs.

<cftransaction>

<cfloop query="whatever">

                        <cfquery>insert....</cfquery>

                        <cfquery>insert....</cfquery>

                        <cfquery>insert....</cfquery>

</cfloop>

</cftransaction>

Steve Nelson

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---