Last page pagination problem

peter_k

I've come across an odd one - the last page of my pagination is displaying a blank page.

If the number of records to be displayed on the last page is not equal to the iDisplayLength parameter, all I see is a blank page.

Co-incidentally (maybe), I just had a look at http://live.datatables.net/ and the live example shows 57 records, but pagination doesn't seem to go past record 50. Where are the other 7 records? It looks like the last page that can be displayed is the last page full of records.

I'm probably missing something, but can anyone explain this?

Here's my initialisation code -

$(document).ready(function() {
$('#my_list').dataTable({
"dom": '<"toolbar">rtip',
"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
"iDisplayLength": 50,
"oLanguage": {
"sInfo": 'Showing END Records.',
"sInfoEmpty": 'No entries to show',
"sEmptyTable": "No Sources found currently, please add at least one.",
},
columnDefs: [
{ type: 'date-eu', targets: 0 }
]
});
$("#my_list tr").css('cursor', 'pointer');
} );

In the my_list table, i use a sql query and iterate through a result record set to create a table line per record. All works beautifully except no last page!

Thanks,

Peter.