Ryan Farrell wrote: > Ok, we are thinking about setting up 2 port redirectors/load balancers > (hardware) and 5 separate servers running CF 5. So, the only problem > is that some of our code has named locks to prevent simultaneous > record insertions on a particular table. I can't think of any way to > make a lock recognizable to another server, but maybe someone out > there has a neat trick or two. Or, maybe we can eliminate the need > for the lock: how do some of you handle the process of inserting data > into a table that generates an autonumber and then figuring out what > number was just generated?
Transactions, stored procedures or built-in functionality of the database server to return the generated number, or a combination of the above. Anyway, this is best handled in the database server, not in CF. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.