What DBMS are you using Oracle, MS SQL Sever, Etc? Your Database system may offer a solution. I know Oracle has a way to handle this and I think MS SQL has a way too.
-John- At 09:19 AM 10/28/2002 -0600, you 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? Any help >would be greatly appreciated. > >Thanks, > >Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
