Problem with Parameters in custom queries using node.js

Wappler Version: 3.6.1
Operating System: Windows, using node.js in Docker

Expected behavior

In a Database custom query I try to use parameters in the LIMIT part of the select, sample:
SELECT * FROM users LIMIT :P1,:P2
or
SELECT * FROM users LIMIT :P1 OFFSET :P2

This adds single colons ’ arount the values of :P1 and :P2, which causes a SQL error when hiting th run button. sample:
SELECT * FROM users LIMIT ‘10’ OFFSET ‘2’

The problem only comes in node.je environment. PHP environment works ok.

Please also see:
https://community.wappler.io/t/use-mysql-stored-in-paged-query/28540/9

Thank you for checking into this!

1 Like

@patrick any news on this bug in NodeJS? I can’t use LIMIT in custom query

This is a 2 years old topic reporting issues in Wappler 3 … now we are on Wappler 5. If you have some issue in Wappler 5 please report it with as much details as possible in a new topic.