Server-Side Pagination Returns only 1 page of my table

prenotrigger

Hello DataTable users and devs,

I find this library very helpful and a time saver. I'm using the latest version of (1.6.1) and jquery 1.4.1. Everything worked out flawlessly after i copied the code from the example page and replaced some of the query values according to my needs. I encountered a slight problem though or i maybe miss looking a simple error.

Heres a screenie -> http://img51.imageshack.us/img51/3244/screen1ui.jpg

The data table is returning the supposed data, limits and sorts accordingly, problem is the pagination returns only one page which is suppose to display more pages according to the limit. I'm really new with this so please bare. thanks in advance.

emjay2

check what you are putting into iTotalDisplayRecords it should be the recordcount after filtering, not the number of rows you have returned in the json.

prenotrigger

thanks emjay2, figured i forgot to include this on the query -> SQL_CALC_FOUND_ROWS