Datatables update and save single cell on click

noslan

I'm able to update, using fnupdate, a single cell on click using this code:
[code]
$(document).ready(function() {
$('#example').on( 'click', 'td:nth-child(12)', function () {
oTable = $('#example').dataTable();
var aPos = oTable.fnGetPosition( this );
alert(aPos);
oTable.fnUpdate( 'new data', aPos[0], aPos[1] );
} );
} );
[/code]
What I need is to save this new change or toggle in db, but its not working with the above code, is there any way to reach it?

allan

Are you using Editor? If so, you need to use the `edit()` API method: https://editor.datatables.net/api/#edit . Using the API you can automatically create the edit, set the values and then submit the form for saving to the database.

Allan

noslan

yes I'm using editor, I'm gona check it right now, Thanks!

noslan

So, I'm interested in "// Automatically submit an edit without showing the user the form"
[code]
editor.edit( TRnode, null, null, false );
editor.set( 'name', 'Updated name' );
editor.set( 'access', 'Read only' );
editor.submit();[/code]

TRnode should be "this"?

allan

Your event handler is on the `td` element, while the `edit()` method expects a `tr` element as the first parameter. So `this.parentNode` will do it in the above case.

Allan

noslan

Thanks Allan, working as expected!