I have a DataStore on the client and I have attached a grid to the dataStore, and it is loading the data. There is also a form bound to the grid.
When I make a change to the data in the form, I can see that it is submitting the ‘update’ post to the server. The server, however, is returning the current table, without updating the data.
I turned on Data connector logging on the server, and it is only showing the "Select * " query. Again, no attempt to update.
Here’s my server side code
require("connector/data_connector.php");
$res=mysql_connect("localhost","XXXXX","XXXXXX");
mysql_select_db("XXXXXX");
$userConn = new DataConnector($res,"MySQL");
$userConn->enable_log("logs/admin_datalog.txt");
$userConn->render_sql("SELECT * FROM users", 'id', " username, password, firstname, lastname");
Here’s the datalog.txt
====================================
Log started, 24/10/2011 05:10:33
====================================
SELECT * FROM users
Done in 0.01502799987793s
====================================
Log started, 24/10/2011 05:10:42
====================================
SELECT * FROM users
Done in 0.0011248588562012s
====================================
Log started, 24/10/2011 05:10:10
====================================
SELECT * FROM users
Done in 0.012408971786499s
====================================
Log started, 24/10/2011 05:10:20
====================================
SELECT * FROM users
Done in 0.0010349750518799s
Is there something else I need to do to enable CRUD? I am using dhtmlX 3.0 Professional.
Thank you,
Rob
PS - I had a problem that when I submitted the data, it was popping an “Error type: LoadXML” error. (I was using JSONDataConnector and type:“json” on the client.) That forced me to switch to XML, and I haven’t had that error anymore. But the updates still aren’t occuring…