Variable in SQL

[Matthew]

Hi,

I am attempting to use a variable in an SQL query, but each time I do, I receive an error.

message:"bind message supplies 1 parameters, but prepared statement "" requires 0"

SQL

and name ilike '%{{selectName.value}}%'

My SQL query works fine whenever I type in the string, but I cannot figure out why there's an error.

[ScottR]

Query with variable not prepared

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 prep…

[Matthew]

Thank you for the help!