Phil,
I suggest you try different DSN names in the same CFtransaction, it should
error out.
With SQL server you could reference the dbname..tablename.column
Neil
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 10:10 AM
Subject: RE: "Newbie" trying to understand CFTRANSACTION
> > Interesting, in CFTRANSACTION you have to reference the same DSN.
> > I wonder how Phil uses multiple DSN's between CFTRANSACTION Tags?
>
> Interesting, I wonder why the documentation says;
> Within one transaction block, you can write queries to more than one
> database; however, you must commit or rollback the transaction to a
> particular database prior to writing a query to another database.
>
> As long as you handle the isolation properly, you can work with multiple
> DSNs
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
