so do i, oddly enough. :)
christopher olive, cto, vp of web development
cresco technologies, inc
410.931.4092
http://www.crescotech.com
-----Original Message-----
From: Steve Oliver
Sent: Tuesday, January 29, 2002 3:21 PM
To: CF-Talk
Subject: RE: Getting the id of the row you just inserted...
I do it this way
<cftransaction>
<cfquery name="insertRecord" datasource="foo">
SET nocount on;
INSERT INTO table
(col1, col2, col3)
VALUES
('blah', 'blah', 'blah');
SELECT @@Identity as NewID;
SET nocount off;
</cfquery>
</cftransaction>
This gives #insertRecord.newID# the ID you just inserted.
______________________
steve oliver
cresco technologies, inc.
http://www.crescotech.com
-----Original Message-----
From: Voris, Jim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 3:12 PM
To: CF-Talk
Subject: Getting the id of the row you just inserted...
It seems to me that there are three basic ways to get the id of the row
you
just inserted.
1) @@identity
and
2) cflocking the insert statement and the select max(id) statement.
and
3) qualifying the select max(id) statement to avoid problems caused by
multiple threads.
I'm curious which method people use and which they find to be the best.
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
