Mainly performance loss, you don't want to hold a 'lock' on DB for too long.
Keep anything inside cftransaction tag to the minimum, especially don't
print long data results to the screen, or worse, do IO operations.

TK
  -----Original Message-----
  From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 02, 2004 2:30 PM
  To: CF-Talk
  Subject: RE: cftransaction HELP Please...

  Why? Performance loss? Security?

  ----- Original Message -----
  From: "Pascal Peters" <[EMAIL PROTECTED]>
  Date: Mon, 2 Feb 2004 14:14:18 +0100
  To: CF-Talk <[EMAIL PROTECTED]>
  Subject: RE: cftransaction HELP Please...

  It is possible, but I do not recommend.

  > -----Original Message-----
  > From: Spectrum Web [mailto:[EMAIL PROTECTED]
  > Sent: maandag 2 februari 2004 10:19
  > To: CF-Talk
  > Subject: Re:cftransaction HELP Please...
  >
  > Right?? It's possible to insert another CF scripts inside
  > cftransaction tags? Do you recommend?
  >
  > Thanks once again
  >
  >
  > >This is possible. However, you have an error with your
  > <cftransaction>
  > >tags. They ALWAYS require an end tag.
  > >
  > >  <cfif IsOK>
  > >    <cftransaction action="">   > >  <cfelse>
  > >    <cftransaction action = "">   > >
  > >> -----Original Message-----
  > >> From: Spectrum Web [mailto:[EMAIL PROTECTED]
  > >> Sent: zondag 1 februari 2004 11:06
  > >> To: CF-Talk
  > >> Subject: Re:cftransaction HELP Please...
  > >>
  > >> Thanks James
  > >>
  > >> it's possible to insert pieces of scripts inside
  > cftransaction blocks?
  > >>
  > >> Like this:
  > >>
  > >>
  > >> <cfset IsOK = True>
  > >> <cftransaction action="">   > >>   <cftry>
  > >>     <cfquery to read from A>
  > >>     <cfcatch>
  > >>       <cfset IsOK = False>
  > >>     </cfcatch>
  > >>   </cftry>
  > >>
  > >> <CFMAIL ...>
  > >>
  > >>   <cfif IsOK>
  > >>     <cftry>
  > >>       <cfquery to save in B>
  > >>       <cfcatch>
  > >>         <cfset IsOK = False>
  > >>       </cfcatch>      <
  > >>     </cftry>
  > >>
  > >>
  > >> <CFMAIL ....>
  > >>
  > >>     <cfif IsOK>
  > >>       <cftry>
  > >>         <cfquery to delete from A>
  > >>         <cfcatch>
  > >>           <cfset IsOK = False>
  > >>         </cfcatch>      <
  > >>       </cftry>
  > >>     </cfif>
  > >>   </cfif>
  > >>
  > >>
  > >> <CFMAIL...>
  > >>
  > >>   <cfif IsOK>
  > >>     <cftransaction action="">   > >>   <cfelse>
  > >>     <cftransaction action = "">   > >>   </cfif>
  > >> </cftransaction>
  > >>
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to