> <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>
Database transactions must use the same database connection, which means the
same datasource, username and password basically. All CF does is tell the
database to treat the two queries as a single transaction, but the actual
transactional processing is performed by the database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
