Hi –
Trying to figure out how to do get serverside paging/sorting/filtering to function using MSSQL.
Unfortunately, the PHP examples in the “PHP Integration” documentation are all written using MySQL.
There are various MySQL functions in those examples that don’t carry over to MSSQL [specifically, LIMIT, SQL_CALC_ROWS() and FOUND_ROWS() ].
I’ve had some success with isolated serverside paging by replacing the SQL_CALC_ROWS()/FOUND_ROWS() functionality with the MSSQL commands ROW_NUMBER() OVER (ORDER BY) and @@ROWCOUNT, but things get very confusing and seem not to work well when I review the documentation examples where paging/sorting/filtering are combined, and then try to convert those examples to MSSQL-friendly code.
Is there any experience in performing these serverside grid functions using PHP written specifically for MSSQL?
thanks,
-Jason
