jQuery Datatables pagination setting

datatables, javascript, jquery, pagination

Solution

try this:

$("#myDataTable").dataTables({
     "bJQueryUI":true,
      "bSort":false,
      "bPaginate":true,
      "sPaginationType":"full_numbers",
       "iDisplayLength": 10
});

Problem

I'm trying to work with the pagination of the jquery datatables. I load the data with ajax. My response is now: ``` aaData: [[:anonymous:, null, 2012-07-29 08:28:21, 0, 85 million, null],…] iTotalDisplayRecords: 70 iTotalRecords: 70 sEcho: 1 ``` All of my records (70) are shown, how can I make them paginate and have for ex 10 records per page? I tried settings iTotalDisplayRecords to 10 but it shows the same result. My datatable init: ``` myDataTable = $('#datatablesresults').dataTable({ bProcessing : true, sProcessing : true, bServerSide : true, sAjaxSource : '/results/load-results?' + getParams, aoColumnDefs : [{'bSortable' : false, 'aTargets' : ['no-sort']}], // make the actions column unsortable sPaginationType : 'full_numbers', fnDrawCallback : function(oSettings) { _initTable(); } }); ```

Original source