More than 10 records (iDisplayLength ?)
More than 10 records (iDisplayLength ?)
Hi,
I just start working with DataTables and it's really great. At the moment I can't get more than 10 records, I searched the forums and think it's "iDisplayLength" I need, but it seem's not to work.
I just want the Table "higher" and showing more records than 10
You can see my example page at: http://www.reticon.de/dataTable/medientipps.php
(Server-Side with sAjaxSource)
My Javascript ist looking like that:
[code]
$(document).ready(function() {
oTable = $('#example').dataTable( {
"oLanguage": { "sUrl": "./de_DE.txt"},
"bAutoWidth": false,
"iDisplayLength": 200,
"sDom": "frtiS",
"bDeferRender": true,
"oScroller": {
"serverWait": 500
},
"bStateSave": true,
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollX": '950px',
"sScrollXInner": "900px",
"sScrollY": '200px',
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "details_col.php",
"aoColumns": [
{ "sClass": "center", "bSortable": false, "sWidth": "15px" },
{ "sClass": "center", "bSortable": true , "sType":"date", "sWidth": "80px"},
{ "sClass": "left" , "sWidth": "80px"},
{ "sClass": "left", "sWidth": "50px" },
{ "sClass": "left","bSortable": false, "sWidth": "400px" },
],
"aaSorting": [[1, 'desc']],
"aaSortingFixed": [[1,'desc']]
} );
$('#example tbody td img').live( 'click', function () {
var nTr = this.parentNode.parentNode;
if ( this.src.match('details_close') )
{
/* This row is already open - close it */
this.src = "./details_open.png";
oTable.fnClose( nTr );
}
else
{
/* Open this row */
this.src = "./details_close.png";
oTable.fnOpen( nTr, fnFormatDetails(nTr), 'details' );
}
} );
} );
[/code]
Perhaps someone can see what I'm doing wrong?
Thanks and best regards,
Martin
I just start working with DataTables and it's really great. At the moment I can't get more than 10 records, I searched the forums and think it's "iDisplayLength" I need, but it seem's not to work.
I just want the Table "higher" and showing more records than 10
You can see my example page at: http://www.reticon.de/dataTable/medientipps.php
(Server-Side with sAjaxSource)
My Javascript ist looking like that:
[code]
$(document).ready(function() {
oTable = $('#example').dataTable( {
"oLanguage": { "sUrl": "./de_DE.txt"},
"bAutoWidth": false,
"iDisplayLength": 200,
"sDom": "frtiS",
"bDeferRender": true,
"oScroller": {
"serverWait": 500
},
"bStateSave": true,
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollX": '950px',
"sScrollXInner": "900px",
"sScrollY": '200px',
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "details_col.php",
"aoColumns": [
{ "sClass": "center", "bSortable": false, "sWidth": "15px" },
{ "sClass": "center", "bSortable": true , "sType":"date", "sWidth": "80px"},
{ "sClass": "left" , "sWidth": "80px"},
{ "sClass": "left", "sWidth": "50px" },
{ "sClass": "left","bSortable": false, "sWidth": "400px" },
],
"aaSorting": [[1, 'desc']],
"aaSortingFixed": [[1,'desc']]
} );
$('#example tbody td img').live( 'click', function () {
var nTr = this.parentNode.parentNode;
if ( this.src.match('details_close') )
{
/* This row is already open - close it */
this.src = "./details_open.png";
oTable.fnClose( nTr );
}
else
{
/* Open this row */
this.src = "./details_close.png";
oTable.fnOpen( nTr, fnFormatDetails(nTr), 'details' );
}
} );
} );
[/code]
Perhaps someone can see what I'm doing wrong?
Thanks and best regards,
Martin
This discussion has been closed.
Replies