Just a string for the uuid. On 1/8/06, Baz <[EMAIL PROTECTED]> wrote: > James, in which cases is it not 100% reliable? Are the CF-Talk archives > searchable? > > Ryan, your method seems ideal... but I think it would take me a month to do > it... what DB datatype is your UUID? > > Cheers, > Baz > > > -----Original Message----- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 08, 2006 8:08 PM > To: CF-Talk > Subject: Re: Get last inserted ID > > What I usually do is have a column that just holds a specific > timestamp or uuid of some sorts. I create a variable to hold the > timestamp or uuid right before the insert query, then I select against > the table looking for that timestamp or uuid. If you are using a db > that stores a pretty detailed timestamp, especially down to the > millisecond (not sure how mysql does it), that would work very well. > And if you can use a uuid for the primary key instead of an > autonumber, then you will have the id before you enven to the insert > statement. > > Just some ideas. > On 1/8/06, James Holmes <[EMAIL PROTECTED]> wrote: > > It's only 100% reliable if you use a serializable transaction, as far > > as I remember. This is certainly the case with Oracle. > > > > There is an extensive thread on this in the archives somewhere. > > > > On 1/9/06, Baz <[EMAIL PROTECTED]> wrote: > > > Is this the best way to do this: > > > > > > <cftransaction> > > > <cfquery name="InsertAddress" datasource="#DSN#"> > > > INSERT INTO Address (City) > > > VALUES (<cfqueryparam value="#City#" cfsqltype="cf_sql_integer" />) > > > </cfquery> > > > > > > <cfquery name="getInsertedID" datasource="#DSN#"> > > > SELECT MAX(AddressID) as MaxID > > > FROM Address > > > </cfquery> > > > </cftransaction> > > > > > > I'm using MySQL. > > > > -- > > CFAJAX docs and other useful articles: > > http://jr-holmes.coldfusionjournal.com/ > > > > > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54