No it's not... The question I took to assume this!!
1) cfquery Insert 2) cfquery Select If there is no trigger then between the insert and the select it is very possible that another user might insert a new record. If this is done in a stored proc then you are right, it will not happen. But if its written in 2 cfqueries, it is very likely that it will happen. -----Original Message----- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Sunday, 17 February 2002 2:15 PM To: CF-Talk Subject: Re: How do you get the ID number of newest record added to a table? > It is except if someone puts another row in the table at the time SQL > gets the @@identity... horse puckey. only chance of that is if your own connection inserts into a table with a trigger that inserts into another IDENTITY table. and thats handled easily enough within teh trigger itself. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 2/14/2002 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
