Manually increase 100 record limit
Manually increase 100 record limit
CloudVGP
Posts: 4Questions: 1Answers: 0
Hi experts
Am working ASP/SQL website and redering database records using this awesome DataTables plugin.
But as i constated, it's fetching only 100 records. I have 1500+ records. But it only showing 100 records.
Showing 1 to 25 of 100 entries
How can i increase MANUALLY the limit ?
BTW: i cannot use the api, or php or Json. Am getting the records directly from DB to HTML
This discussion has been closed.
Answers
Sounds like its a change outside of Datatables control. You will need to look at your SQL query to see why it is limiting the records fetched.
Kevin
There isn't a limit as far as DataTables is concerned, so you'll want to look at the server end. Are you using
serverside?Colin
yes sure i tried serverside = true and serverside = 1 in but it's displaying only 100 records. my sql is returning well 1341 records in my old page, i just made a new page with same query, but instead i changed my table to datatables.net
see here
http://bootstrap.controle-reglementaire.fr/shopa_editdisplay.asp?table=customers
solved. yes you were right. i had a server side error that i missed to see and limiting query results.
thx very much