I am using API to update a single cell in many rows of my grid, all at one time, and am getting the following error:
PHP Fatal error: Unknown: Input variables exceeded 1000.
I think I understand why this is happening - because the number of rows being updated times the number of cells in each row exceeds the allowed number of input variables.
I am attempting to solve this problem by sending only the changed cell for each row instead of all the cells. To do this, I am using the following:
cells(rId, 1).setValue(0);
cells(rId, 1).cell.wasChanged = true;
dp.setUpdated(rId,true);
dp.sendData();
However, all cells are still being sent, and I still get the same error. How do I send only the changed cell?
I added the following line:
dp.enablePartialDataSend(true);
And I also have the following lines:
briefGrid.forEachRow(function(rowID){
briefGrid.cells(rowID,1).setValue(1);
briefGrid.cells(rowID,1).cell.wasChanged = true;
dp.setUpdated(rowID,true);
});
var tempsend = setTimeout(function(){dp.sendData()},200);//200 = 2 tenths of a second
tempsend;
Initially, it looked like this worked. However, when I reloaded my grid (and later looked in phpmyadmin) I found that instead of updating the cell in each of the rows, it deleted each of the rows that had been currently loaded in the grid.
Fortunately, I have a backup of the database. Do you know what might be wrong?
Thanks
Are you using dhtmlxConnector on server side or a custom code?
The above mentioned enablePartialDataSend will send only updated cells, but it not compatible with connector - you need to use a custom code in such case. ( When connector used - it always updates all fields in the row, so when only one cell info is sent - it wil update all other cells with empty values )
Alternatively you can still use connector on server side, but use custom logic through beforeUpdate or similar event, where you can form and exec sql which is necessary in your case ( one, which will update only cell in question )