Search

Thank you Allan, this works great.

Yeah !! Thx Allan. Loïc

1 - what is the best way to get the total number of rows? Currently with this plug-in: http://datatables.net/plug-ins/api#fnPagingInfo . v1.10 will have something similar built in. 2 - And how do I customize the number of rows to show in the listbox (it's fixes to 10/25/50/1000) As you say - aLengthMenu :-) Allan

Is there a way I can use the mData property to silently drop null values in when properties aren't defined? Use sDefaultContent and set it to an empty string. Then null or undefined data (as is the case here) will be shown with the default content rather than showing a warning. Allan

Thanks for the tips Allan! That was exactly what I was looking for! Below is the code I am using in case anyone else needs something similar. [code] $(document).ready(function() { oTable = $('#example').dataTable(); } ); [/code] add some code for when a row is clicked: [code] $('#example').on('click', 'tr', function (e) { e.preventDefault(); var data = oTable.fnGetData(this); //data for selected record var rowPosition = oTable.fnGetPosition( this ); //position of record in table //alert(data[0]); //id of record in my case //my custom modal code //after submitting form I then just call this to update the row... oTable.fnUpdate( ['id', 'name', 'email', 'phone_styled', 'phone_raw'], rowPosition); // insert new data in row. } ); [/code]

Oops, sorry I realize I was missing "sPaginationType": "bootstrap",

Thanks Allan, I've used the flag method as suggested and it seems to work just fine. [code] var halt=false; $(document).ready(function() { editor = new $.fn.dataTable.Editor({ ajaxUrl: "./worklog.ajax.php", domTable: "#worklog", events: { onOpen: function(){halt=true; }, onClose: function(){halt=false;} }... [/code] [code] setInterval(function() { if(!halt) { dTable.fnReloadAjax("./worklog.ajax.php"); } }, 120000); [/code]

You've enabled server-side processing, but your data source doesn't implement server-side processing. If you want to use server-side processing you need to implement the protocol described here: http://datatables.net/usage/server-side For that few rows though, I'd suggest you don't use server-side processing - there is no need. Allan

Problem solved. I used mRender for input.

Add it to the part of the script where the WHERE section is built up. Around line 100. Allan