Re: CFTRANSACTION

[Paul Giesenhagen]

That is because TRANSACTIONS are not CF they are somethign your DB uses it is something that DB will do to roll back if there is a problem, it is not a CF issue...  You must have your transactions all using the same datasource.

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com

  ----- Original Message -----
  From: vishnu prasad
  To: CF-Talk
  Sent: Thursday, September 16, 2004 12:26 AM
  Subject: Re: CFTRANSACTION

  when i run the query like this its working fine
  <cfquery datasource=one name=one>
  insert statment
  <cfquery>
  <cfquery datasource=two name=rwo>
  insert statment
  <cfquery>

  but when i put in transcation i got the error

  <CFTRANSACTION>
  <cfquery datasource=one name=one>
  insert statment
  <cfquery>
  <cfquery datasource=two name=rwo>
  insert statment
  <cfquery>
  </CFTRANSACTION>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---