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
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
[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
]]
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
How do I get the Unique ID from the last field I inserted?
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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
it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis
Let's Roll
- Todd Beamer, Flight 93
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:49 PM
To: CF-Talk
Subject: Las record
How do I get
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
8 matches
Mail list logo