Re: Las record

Bryan said: Different DB's provide different ways of doing this, but the only universal way I know of is this: cftransaction .. /cftransaction 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

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: cftransaction cfquery... do the insert /cfquery cfquery... SELECT

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 increments ascending: cftransaction

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: cftransaction cfquery... do

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

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: cftransaction cfquery... do the insert /cfquery cfquery... SELECT MAX(whateverID) as

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?