Server Side Loading Doesn't Show All Records

chris.cavage

Hi,

Love the app.

I am loading data from a MYSQL database, and it works great. I also use TableTools to put custom filters at the column footers.

The only thing is that when my info is loaded is says below the custom filters:
"Showing 1 to 117 of 117 entries (filtered from 2,344 total entries)"

If I enable pagination it will only paginate to record 117.

I would like ALL records to show. I would eventually enable the infinite vertical scroller also, but how do I get all records - why is it filtering?

Here is my code:

[code]

@import "DataTables/media/css/demo_page.css";
@import "DataTables/media/css/demo_table.css";
@import "DataTables/extras/TableTools/media/css/TableTools.css";








var asInitVals = new Array();

$(document).ready(function() {
oTable = $('#appts').dataTable( {
"sScrollY": "300px",
"bPaginate": false,
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"
},
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "DataTables/phpqueries/appts.php"
} );

$("tfoot input").keyup( function () {
/* Filter on the column (the index) of this element */
oTable.fnFilter( this.value, $("tfoot input").index(this) );
} );


$("tfoot input").each( function (i) {
asInitVals[i] = this.value;
} );

$("tfoot input").focus( function () {
if ( this.className == "search_init" )
{
this.className = "";
this.value = "";
}
} );

$("tfoot input").blur( function (i) {
if ( this.value == "" )
{
this.className = "search_init";
this.value = asInitVals[$("tfoot input").index(this)];
}


} );

} );

[/code]

[code]



Appt Date
First
Last
Appt Type
How Heard
Promo Info
Office





Loading data from server
















[/code]