jQuery Grid Plugin - jqGrid - Topic: Set flag in mySql , when row is selected to lock/unlock a row

Lotte on Set flag in mySql , when row is selected to lock/unlock a row

Mon, 02 Mar 2009 17:18:19 +0200

Hello Tony,

thank you for your anwer. I did it server side and it works.

Comparing the timestamp every row is visible after timeperiode.

tony on Set flag in mySql , when row is selected to lock/unlock a row

Sun, 01 Mar 2009 07:18:02 +0200

Hello,

This is not a trivial task at all. You can use onSelectRow, but you should think about other problems. Suppose I open the grid (using onSelectRow), lock the row and then I close the browser. The lock remain instead that I'm not in application.

IMHO better way is to check the row when is updated server side. You can check if yhe row is locked (server side) and notify the user if it is locked. This way you will left a complex logic client side.

Best Regards

Tony

Lotte on Set flag in mySql , when row is selected to lock/unlock a row

Thu, 26 Feb 2009 13:12:14 +0200

At first: fantastic plugin!

My grid works well! Only one problem: I want to call a yx.php, when a row is selected by onSelectRow or other methode to lock/unlock a row in database.

Or is there a better possibility to hide a row for users which are in use (editing etc) ?

Best regards

Charlotte