Server Side Searching MSSQL-PDO

acidburn78

I have a Problem i customized the ssp.class.php with this forum entry https://datatables.net/forums/discussion/32123/server-side-processing-with-pdo-mssql

It works fine, the only thing don't work is global and column search. Every Time i try to search anything i get an Error-Message:

{"error":"An SQL error occurred: SQLSTATE[IMSSP]: Tried to bind parameter number 65536. SQL Server supports a maximum of 2100 parameters."}

I use the POST Example with actually 18 columns in my table.

Hope you can help me the Searching funktion

allan

Might be worth posting in the thread you linked to rather than in a new thread. Then the original author of that script might be able to help.

Beyond that, you'd probably need to do some debugging.

Allan