No worries, Ali... that's why some of us join these lists. I'm interested to know, though, why you don't have your system either use an internally regulated ID number (like an auto-increment constraint on the column) or use something like a UUID that's generated outside the database...
Having to do workarounds like this is kinda scary, eh? Laterz! J On 4/20/05, Ali Awan <[EMAIL PROTECTED]> wrote: > Thanks to everyone who responded to this thread. > Especially Jared and Jochem, I will try out the <cftransaction> with a > serializable isolation level. I think that will solve the problem. > > Thanks again, > Ali -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203795 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
