Datatables pagination problem with SQL Server 2008

Léa TALLEC

Hello,

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.

kthorngren

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?

Kevin

Léa TALLEC

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.

allan

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.

Allan