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. ______________________________________________________________________ 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
