The short answer is no, not using MySQL built in transaction system. What I do for things like this is add a field to the table that indicates whether or not the record is locked. It is usually a Tiny Int that I just set to 1 or 0.
Hope that helps. j----- k----- On Tuesday 09 March 2004 06:24 am, Sagara Wijetunga wrote: > 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 -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... .... ..- .- -.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
