Only seems to impact running a paginated query using MS Sql, I’m using an Azure SQL database. Issue persists with hardcoded values in the server query so doesn’t relate to the GET variables being passed. Running the query with an offset value of 0 works fine. The incorrect syntax is always ‘near’ the end of the offset range (so offset of 50 will have ‘incorrect syntax near 75’ error).
Just wondered if you were able to confirm this as a bug?..not desperate for a fix but if I can’t use pagination I need to rethink the page layout/data structure quite substantially. I have to use SQL Server so not an option to shift to MySQL.