Datatables pagination problem with SQL Server 2008

Datatables pagination problem with SQL Server 2008

Léa TALLECLéa TALLEC Posts: 2Questions: 1Answers: 0

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.

Answers

  • kthorngrenkthorngren Posts: 19,924Questions: 26Answers: 4,696

    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 TALLECLéa TALLEC Posts: 2Questions: 1Answers: 0

    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.

  • allanallan Posts: 61,022Questions: 1Answers: 9,951 Site admin

    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

Sign In or Register to comment.