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]
MariaDB does not support ? in this position but you should be able to use this:
let x = 10
let entrys = db.getAllRows(sql("SELECT surname FROM the_table WHERE name='John' LIMIT " & $x))