Without testing it here, are you getting an SQL error?  I think SQL doesn't allow you to do this, OR it could be the Driver you are using.

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

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

  Hi Paul

  thks for your response,i think its possible in java
  is it not possible to have implement tow phase commit in Coldfusion

  > No, you can only have one datasource per CFTRANSACTION.
  >
  > Would be nice, but it isn't possible.
  >
  > Paul Giesenhagen
  > QuillDesign
  > 417-885-1375
  > http://www.quilldesign.com
  >
  >
   
  > ----- Original Message -----
   
  > From: vishnu prasad
   
  > To: CF-Talk
   
  > Sent: Wednesday, September 15, 2004 11:45 PM
   
  > Subject: CFTRANSACTION
  >
  >
   
  > Hi All
  >
   
  > is it possible to have one CFTRANSACTION for multiple datasource
   
  > i write the follwing code
  >
   
  > <CFTRANSACTION>
   
  > <cfquery datasource=one name=one>
   
  > insert statment
   
  > <cfquery>
  >
   
  > <cfquery datasource=two name=rwo>
   
  > insert statment
   
  > <cfquery>
   
  > </CFTRANSACTION>
  >
   
  > i verify the connection in cf admin ,but when i execute the code i got
  > message as datasource verification failed
  >
   
  > how can i overcome this
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to