Speaking of "purpose-free" the <CFTRANSACTION> is not even reliable for
multiple queries.
I had a problem with users on a high-volume site having OrderIDs duplicated
and caused major problems. I fixed it by getting the ID within my order
query with that lovely SET NO COUNT option in SQL 7.
I wonder if there are going to be any improvements in the future of this
tag?
- BILL -
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 10:06 AM
To: CF-Talk
Subject: RE: CFTRANSACTION
> Yes, as written this use of CFTRANSACTION is purpose-free.
I'll have to remember that phrase... extrememly diplomatic!
Thanks
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopperuk
Telephone +44 (01744) 648650
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
