It's my understanding that CFTRANSACTION may not give guaranteed protection here,
if your database supports row-level locking. Correct?
Howie Hamlin wrote:
> Yep that's it. However, you should do a transaction so that another record
> isn't added while you're fetching the current highest ID.
>
> ----- Original Message -----
> From: "Joshua Tipton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 17, 2001 1:34 AM
> Subject: Last row inserted
>
> > I know this has been asked a million times but what is the best way to
> pull
> > the id of the row last inserted. Isnt select (column name)MAX as
> > (whatever)?
---------------------------------
Gene Kraybill
LPW & Associates LLC
www.lpw.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
