Hi all Is it possible to span a database transaction across multiple CGI scripts? That is, start transaction and lock some records in one CGI script and update and commit in another CGI script.
Here is an example: I have a accounts database. Only one user should edit a given account at any given time. Once an account is open for editing, it should be locked so that other users cannot open in edit mode. Multiple users should be able to edit different accounts. The list.cgi lists accounts. Once click on an account, the edit.cgi reads account info and display in an editable form. This is where I need to lock the account. After editing is completed, user clicks on the Update button and data transfer to process.cgi. After the account is updated, I issue commit and release record locks. I use MySQL 4.x and Perl. Could my requirement be implemented in MySQL? Could somebody please at least give me a hint how to implement this? Many thanks in advance. Regards Sagara __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
