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 connections might be an option, but you can't guarantee your CGI will get the same connection and be able to release the lock! Hope this helps, Ken ----- Original Message ----- From: "Andy Ford" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 26, 2004 10:01 PM Subject: table locking using perl DBI > 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!? > > Thanks > > Andy > > > -- > > perl -e 'print qq^;@) [###]^^qq^z\.MY{eLQ9^' > in:control developer, Telindus, RG27 9HY > DDI: +44 1256 709211, GSM: +44 7810 636652 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]