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:232034 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