Error when choosing more than 20 results per page

Error when choosing more than 20 results per page

andyle2kandyle2k Posts: 5Questions: 1Answers: 0
edited October 2013 in DataTables 1.9
Hello,

I'm having a strange issue with server side (ASP NET/MSSQL) and returning more than 20 results per page. I'm using "sAjaxSource": "Test.apsx".

When I change the iDisplayLength to greater than 20, it gives me an invalid JSON response. Same thing if I do it via the selector.

My ASPX page when called is giving valid JSON responses, when I do a manual call [Test.aspx?sEcho=0&iDisplayLength=21&iDisplayStart=0] it is returning a proper JSON dataset so I don't think it's my SQL.

So if anybody has any clues, can you please help?

Or to troubleshoot, can anybody help with these questions:
1) Can we turn off the results per page selector? I just want it to work for my users while I figure out a solution.
2) Any way either in JS or ASP to display the DataTables AJAX call? As in can we display what all the parameters it is parsing over to my Test.aspx? This will help me check where it's falling apart.

Thank you very much.
This discussion has been closed.