I don't think a flaw in <CFTRANSACTION> would not necessarily be a candidate
for causing this kind of problem. CFTRANSACTION is concerned with defining
a set of (usually) database operations as a "transaction" for roll back
purposes. Most of the problems we've had with this tag stem from misuse as
opposed to reliability of the tag.
Are there problems with this tag that I am not familiar with????
Brian
----- Original Message -----
From: "Bill King" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 11:47 AM
Subject: RE: CFTRANSACTION
> 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