EditableGrid is an open source Javascript library aimed at turning HTML tables into advanced editable components. It focuses on simplicity: only a few lines of code are required to get your first table up and running.
I adapted the editablegrid mysql example to create my own datagrid.
The grid selects from a mysql VIEW but, because of some aggregation, instead updates one of the VIEW's underlying TABLES. This bit works fine.
However, when I come to add a new row, something's not working, and the 'error' display is returned.
I can see that the query executes (the first time) because a new row is created in my table, but neither of the two form values provided are inserted. Regardless of what's submitted, it simply inserts a 0 and a blank value. I think I've updated all relevant files (including the demo.js file), but clearly I've forgotten something. I'm happy to provide code, but I wasn't sure what to provide (I'm not very familiar with GitHub - sorry)
I adapted the editablegrid mysql example to create my own datagrid.
The grid selects from a mysql VIEW but, because of some aggregation, instead updates one of the VIEW's underlying TABLES. This bit works fine.
However, when I come to add a new row, something's not working, and the 'error' display is returned.
I can see that the query executes (the first time) because a new row is created in my table, but neither of the two form values provided are inserted. Regardless of what's submitted, it simply inserts a 0 and a blank value. I think I've updated all relevant files (including the demo.js file), but clearly I've forgotten something. I'm happy to provide code, but I wasn't sure what to provide (I'm not very familiar with GitHub - sorry)