I’m trying to work around the row limitation of 200 when using a SQL SELECT statement by using the OFFSET parameter and a custom state to enable paging.
My SQL statement works when I run it from Navicat and hit the MySQL db directly. But, Bubble is giving me a syntax error when I try using the parameters in the Plugin configuration. I tried several different combinations, without success. This includes trying to configure a parameter for the LIMIT value, which did not work either.
SQL Query:
SELECT
parts.*
FROM parts
WHERE IFCLS = ?
LIMIT 100
OFFSET ?
All help is much appreciated.
Thank you.