Problem when updateing rows....

Suite and Optimus Suite 5
#1

I set roco in the grid.
mygrid.getCombo(6).put(0,“Action”);
mygrid.getCombo(6).put(1,“Cancel”);
mygrid.getCombo(6).put(2,“Execute now”);
mygrid.getCombo(6).put(3,“Move to history”);

Then use update.php
myDataProcessor = new dataProcessor(“update.php”);

In update.php
if($_GET[$rowId_c6] == ‘1’)
$_status = ‘XXX’;
else
$_status = ‘OOO’;

$sql = “UPDATE AMR_TASK SET STATUS= ‘$_status’ WHERE
TASKID=’”.$_GET[$rowId."_c0"]."’";

But it does NOT work,
Any idea??

#2

You are using custom code, not connectors, right?

if($_GET[$rowId_c6] == '1')

not quite sure is it problem or not, but valid code must look as

if($_GET[$rowId."_c6"] == '1')
#3

Yes!!
It works!!!
Thank you very much.

How can I let grid autorefresh
after I changed the coro and updated database?

#4

You can either reload grid

grid.clearAll()
grid.loadXML(url)

or update only necessary rows

grid.updateFromXML(url)

#5

Thank you!
Err…
But how can I use them?
Where do I insert them in code?
(ps.I load and update all by php not xml)

===part code start===

mygrid.init();
mygrid.setSkin(“dhx_skyblue”);
mygrid.enablePaging(true, 100, 15, “pagingArea”, true, “infoArea”);
mygrid.enableRowsHover(true,‘grid_hover’);
mygrid.setPagingSkin(“bricks”);
mygrid.loadXML(“get.php”);
myDataProcessor = new dataProcessor(“update.php”);
myDataProcessor.setTransactionMode(“GET”, true);
//myDataProcessor.setUpdateMode(“off”);
myDataProcessor.init(mygrid);

===part code end===

#6

myDataProcessor.attachEvent("onAfterUpdate", function(){ grid.clearAll() grid.loadXML("get.php") })

#7

Thank you ver much!!
It works!