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:228787 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54