I'm having a problem paginating Datatables using data from SQL Server 2008.
Here is the error :
AggregateError: select (the data) order by (a data) desc offset @p0 rows fetch next @p1 rows only
Do you have a solution?
Thanks for your help.
First start by providing more info. I'm guessing you have serverSide: true in you Datatables config. Is this true?
What are you using for your server side processing script? Is it supplied by Datatables?
Yes, I have serverSide: true
For server-side scripting, I use the Editor.js library from Datatables.
The data is displayed correctly in the table, the filters work, so does the number of entries, but the pagination sends itself an error.
We use OFFSET / FETCH NEXT in the query to do the pagination, which was introduced in SQL Server 2012. See the comment in the code here.
I'm afraid that server-side processing with older versions of SQL Server is not supported with the Editor libraries we provide.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.