WORKS => let entrys = db.getAllRows(sql"SELECT surname FROM the_table WHERE 
name='John' LIMIT 10")

LIMIT AS PARAM NOT WORKING => let entrys = db.getAllRows(sql"SELECT surname 
FROM the_table WHERE name='John' LIMIT ?","10")

I can't manage to pass LIMIT in as a param. If I would pass in name as param it 
works but not LIMIT. I've also tried with db.exec but that also fails

With getAllRows I get error => ou have an error in your SQL syntax; check the 
manual that corresponds to your MariaDB server version for the right syntax to 
use near ''10'' at line 1 [DbError]

Reply via email to