Server Side Processing MS SQL 1.10.2
Server Side Processing MS SQL 1.10.2
werbeacc
Posts: 7Questions: 2Answers: 0
Hello,
im looking for an MS SQL optimized version of the new ssp_class.php (Datatables 1.10.2).
For example, the paging function should not work because a LIMIT statement is used.
Has anyone ever adapted it or can help to configure it for MS SQL.
Can further instructions cause problems?
I use successfully PDO with Sybase for the MS SQL Connection.
This discussion has been closed.
Replies
Did you search the forum?
For example: http://datatables.net/forums/discussion/9683/pagination-with-mssql-backend-example-code
Thanks, but i have problems to implement this in this snippet:
also the $resFilterLength function must be edited for MS SQL
Its now successfully implemented. Definitely not the most efficient way, but it works for the beginning. I used the new OFFSET in MS SQL 2012. So its only since 2012 compatible...
For someone who needs it too:
and