Hello everyone,
I currently use the following query which I execute on form submission. The problem is that it will always result in an error when I'm using a variable. (In this case the value of my search_query input).
You'll see the variable below. However, if I leave the variable away and just manually enter for example, my name, it seems to be working. So the issue does not lay with the query. At least, that's what I think.
The error I get is
bind message supplies 1 parameters, but prepared statement "" requires 0
If I hover over the variable in the query editor, I can confirm that the variable is working. I do get the input value, however when Queried, it returns in a broken query.
What am I doing wrong here?
SELECT
"user".first_name,
"user".last_name,
"user".email,
user_settings.token
FROM
"user"
INNER JOIN user_settings ON "user".id = user_settings.owner_id
WHERE
lower(concat("user".first_name, "user".last_name)) LIKE '%{{search_query.value}}%'