Editable Grid is not Saving the update

leo086

Hi all , am trying to use the Editable Gridview for Server Side Datasource , but the problem is that whenever i edit , the modification will be lost ..and nothing happen to the Data ,,,here i will post my initiation of the table

[code]
<!-- Initaite the table instance -->

var oTable;
$(document).ready(function() {
oTable = $('#Myexample').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "examples/examples_support/server_processing.php",
"fnDrawCallback": function () {

$('#Myexample tbody td').editable( 'examples/examples_support/editable_ajax.php', {
"callback": function( sValue, y ) {
/* Redraw the table from the new data on the server */
oTable.fnDraw();
},
"height": "20px"
});
}
} );
} );




[/code]


advice please :)

allan

Have you modified "examples/examples_support/editable_ajax.php" to save the value to the database?

Allan

leo086

how could i know which column is the modified one ?! .. i got the the post value on that page .. but actually didnt do any update on the data cz am not sure yet how to perform it

allan

This is one of the reasons why there isn't a completely defined concrete example! I have no idea what the table name is, the columns or even what the db is. So basically, you have the value to insert, you might need to send a little more information with the Ajax request sends (see the jEditable documentation) to say which column it is, and then have a SQL statement which is executed and will update the table.

Allan