RE: Las record

[mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:46 AM To: CF-Talk Subject: Re: Las record Bryan Love wrote: > Different DB's provide different ways of doing this, but the only universal > way I know of is this: > > Assuming the key is numeric and inc

Re: Las record

Bryan Love wrote: > Different DB's provide different ways of doing this, but the only universal > way I know of is this: > > Assuming the key is numeric and increments ascending: > > > do the insert > > > SELECT MAX(whateverID) as maxID >

Re: Las record

Bryan said: >Different DB's provide different ways of doing this, but the only universal >way I know of is this: .. Actually, there's some contention about this method with Oracle. Some poeple say there's an implicit commit with every call from CF to Oracle, thereby blowing away your transactio

RE: Las record

> Sent: Wednesday, September 18, 2002 6:49 PM > To: CF-Talk > Subject: RE: Las record > > > Different DB's provide different ways of doing this, but the only > universal > way I know of is this: > > Assuming the key is numeric and increments ascending:

RE: Las record

SELECTmax(unique_id) FROM tablename -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:49 PM To: CF-Talk Subject: Las record How do I get the Unique ID from the last field I inserted?

RE: Las record

Different DB's provide different ways of doing this, but the only universal way I know of is this: Assuming the key is numeric and increments ascending: do the insert SELECT MAX(whateverID) as maxID FROM tablename

Re: Las record

Explore the custom tag cf_maxID That should do it for you. At 02:48 PM 9/18/02, you wrote: >How do I get the Unique ID from the last field I inserted? > __ Your ad could be here. Monies from ads go to support these lists and p