Bind message supplies 2 parameters, but prepared statement "" requires 1

[Craig_Madsen]

I got it to work with the following syntax on the LIKE statement:

SELECT * FROM roster s
WHERE ({{ !textInput1.value }}
OR s."NAME" LIKE {{ '%' + textInput1.value + '%' }})
ORDER BY s."NAME"