Make sure that you use cftransaction and assuming that your IDs are sequential integers, make sure you sort descending. If you could prevent two trips to the database, I would strongly recommend it.
At 01:03 PM 7/23/2002 -0400, you wrote: >select max > >On Tue, 23 Jul 2002, chris.alvarado wrote: > > > 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 > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists