Re: table locking using perl DBI

2004-04-28 Thread Ken Menzel
Hi Andy, The best way to accomplish this is at an application level, setup a lock table and put your locks in there. There are many methods for handling application locks. Choose one that work for you. With a database level lock, when the connection terminates the lock is released. Persistant c

Re: table locking using perl DBI

2004-04-28 Thread Hans-Peter Grimm
Andy Ford wrote: I have a perl cgi script that needs to lock the tables. Unfortunately, as HTTP is a one shot protocol, once the cgi script completes execution, the tables are unlocked. I need it to stay locked until another cgi script unlocks them! Is there any other way of achieving this!? You c