Re: Las record

2002-09-19 Thread Deanna Schneider
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

2002-09-19 Thread Jochem van Dieten
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

2002-09-19 Thread Webmaster
[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

2002-09-18 Thread Joe Eugene
]] 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

Las record

2002-09-18 Thread Webmaster
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

Re: Las record

2002-09-18 Thread Brian Scandale
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

2002-09-18 Thread Bryan Love
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

RE: Las record

2002-09-18 Thread Greg Luce
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