[thelist] @@IDENTITY w/SQL 7 - ColdFusion query

[.jeff]

hello,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: databarn
>
> If that is CF specific, great.  But that SQL structure,
> as such, is dangerous to your intent in a multiuser
> environment unless CF handles the multiple queries
> internally as a single query and presents it to SQL
> Server as such
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

it is my understanding that it indeed does represent the entire string
between the opening and closing cfquery tags as one query.  this fact was
evidenced when i tried to use this syntax with a database that did not
support multiple queries per connection.

ray, you reading this?  can you ask someone there internally how it's
handled?

if you want to make absolutely certain, i'd recommend using cftransaction
instead.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/