Search

size to 10, the paging buttons correctly update and

dialog form with pagination Could you clarify what dialog please? Does it have a DataTable with paging inside it, or is this an Editor form dialog box? Either way, it should be quite possible :-) Allan

parameters will reset the paging / scrolling, which is what

orderable": false, "targets": [1,3] } ], "paging": false, "searching": false, "autoWidth":

is that the bs_full paging type is being added

I've just tried this with my basic server-side processing example: echo json_encode( SSP::complex( $_GET, $sql_details, $table, $primaryKey, $columns, null, "first_name like '%a%'" ) ); And it seems to work as expected (including specifically the paging). Allan

scrollY": "200px", "scrollCollapse": true, "paging": false } ); for( id in

Allan, I have added few lines, magically it started working. Thanks much Allan. searching: false, ordering: true, paging: false, processing: true, deferRender: true,

Could not select database ' ); } /* * Paging */ $sLimit = ""; if ( isset( $_GET['iDisplayStart']

This contentType did not help ... $(document).ready(function() { $('#whs').DataTable( { // "dom": "Tfrtip", "dom": '<"wrapper"Tf<l><"clear"><i><p><t>', "ajax": { "url": "dteditor/dte_whs1.php", "contentType": "application/json; charset=utf-8" }, "columns": [ {"data": "whsid" }, {"data": "whssite" } , {"data": "whstype" } ], "paging": true, "pagingType": "full_numbers", "order": [ 1, "asc" ], 'bAutoWidth': false , "lengthMenu": [[ 100, -1], [ 100, "All"]], } ); } );