How to call query_with_bindings() with quotes in the WHERE clause

[iamrequest]

Hello!

I'm running into an issue where query_with_bindings() isn't recognizing the question mark in my WHERE clause if it's surrounded in single/double quotes.

var query := "SELECT * FROM songs WHERE name LIKE '%?%';"
var params = ["a"]
_db.query_with_bindings(query, params)
print(_db.query_result)

The query succeeds, but I get a warning log in console implying that the binding failed. I can run the same query against the database in DBViewer (substituting the question mark for some string).

SELECT * FROM songs WHERE name LIKE '%?%';
 --> Query succeeded
[]

W 0:15:04:683   db.gd:46 @ query_with_bindings(): GDSQLite Warning: Provided number of bindings exceeded the required number in statement! (1 unused parameter(s))
  <C++ Source>  src\gdsqlite.cpp:367 @ query_with_bindings()

If I remove the quotes, the variable binding work as expected. Is there some secret sauce I'm missing? Thanks!

[2shady4u]

Hello @iamrequest,

What warning log do you get in the console?

[2shady4u]

You can't put bindings inside of quotes in SQLite -> That is why it is not working in your case.

Here are your possibilities:

var query := "SELECT * FROM songs WHERE name LIKE '%' || ? || '%';"
var params = ["a"]
_db.query_with_bindings(query, params)
print(_db.query_result)

or:

var query := "SELECT * FROM songs WHERE name LIKE ?;"
var params = ["%a%"]
_db.query_with_bindings(query, params)
print(_db.query_result)

[iamrequest]

I see, I didn't realize that was an issue. Thanks! 😁