Node Docker Paged queries for MSSQL

Wappler General Bugs
1

windows 10
Wappler 3.8.2

Cannot get paged query results.
first 10 records loads fine, but no more records i loading when you click on page 2.
Get this error “offset @p0 rows fetch next @p1 rows only - Invalid usage of the option next in the FETCH statement”.
complete error in attached filepagedgrid error.zip (615 Bytes)

Identical page in a php project against the same database works fine

1 Like
2

I have the same problem!!! What you do? Left the Wappler? rsrsrs

3

This is a 3 years old topic. If you have a similar issue post a detailed error report explaining the exact problem you are experiencing.