MySQL Forums
Forum List  »  InnoDB

Re: Not locking....
Posted by: Arend Jan Zwart
Date: September 29, 2008 05:03AM

Thanks for the responces ;)
Thats indead my problem...

I wanted to use rowlocking because i have a table with all articles.. if you edit a article i wanted to lock that specific row.

The point is, that i do a select for update and lock the row....

Then i want to edit the article for as long as i want and refresh the page if its necessary...

If someone saves, i want to update it, or cancel if someone cancels....

But i want to row to stays locked until save or cancel has been used. Is that even possible ???

Another questuin is can you ask the DB if a row is locked easely ??

Options: ReplyQuote


Subject
Views
Written By
Posted
2980
September 22, 2008 01:34AM
1671
September 28, 2008 08:27PM
Re: Not locking....
1684
September 29, 2008 05:03AM
1644
September 29, 2008 06:53PM
1644
October 04, 2008 06:03AM
1553
September 28, 2008 10:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.