<cftransaction> do insert
select max(id) from table </cftranascation> -----Original Message----- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 12:05 PM To: CF-Talk Subject: Retrieving last inserted Primary Key I know this topic has been flogged to death, but here it goes again. What is the preferred Method of retrieving the last inserted Primary key? NOT using a stored proc and the @@Identity method, so what about using CF in line queries. Any suggestions? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
