problem with paging and server-side processing

problem with paging and server-side processing

pipp23pipp23 Posts: 1Questions: 0Answers: 0
edited June 2012 in Plug-ins
hello,

I implemented the server-side process, it works correctly with filters and searches but not with paging. the next and previous buttons are not enabled even though the total number of rows are more than 2500 and "iDisplayLength" is enhanced to 20. LIMIT query works properly by 0.20 at the beginning but then I do not know how to change the page. Can you help? here's how to initialize the table:

[code]
source = "index.php?mp=PAGE_ELENCO_ORDINI_AJ";

oTab_elenco_ordini = $('#tab_elenco_ordini').dataTable( {
"bStateSave": true,
"bProcessing": true,
"bServerSide": true,
"bJQueryUI": true,
"sAjaxSource": source,
"sDom": "<'toolbar'>frtip",
"sPaginationType": "two_button",
"iDisplayLength": 20,
"aLengthMenu": [[20, 50, 100, -1], [20, 50, 100, "Tutti"]],
"oLanguage": {
"sProcessing": "Caricamento...",
"sLengthMenu": "Visualizza _MENU_ ordini",
"sZeroRecords": "La ricerca non ha portato alcun risultato.",
"sInfo": "Vista da _START_ a _END_ di _TOTAL_ ordini",
"sInfoEmpty": "Vista da 0 a 0 di 0 elementi",
"sInfoFiltered": "(filtrati da _MAX_ ordini totali)",
"sInfoPostFix": "",
"sSearch": "Cerca:",
"sUrl": "",
"oPaginate": {
"sFirst": "Inizio",
"sPrevious": "Precedente",
"sNext": "Successivo",
"sLast": "Fine"
}
}
})


[/code]
This discussion has been closed.