It does a transaction in the database itself, assuming the database being used supports transactions. This would ensure that you get back the ID that you just inserted.
On 2/11/06, Mike Soultanian <[EMAIL PROTECTED]> wrote: > > Aaron Roberson wrote: > > Mike, > > > > I will look into that. I thought as long as I wrapped the insert user > > query and the select user query (with the max() function) in a > > cftransaction tag that I would eliminate race conditions and therefore > > would return the correct userID. Is that incorrect? > > I believe that cftransaction ensures that both queries will happen > within that page call, but I don't think it ensures that other queries > can't be made against the database. > > Mike > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232035 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
