Hello, I am having problems while querying a database. This query does not work: select "id" from bo.accounts where "id" like '%{{ accountIdInput.value }}%' and it throws the error: bind message supplies 1 parameters, but prepared statement "" requires 0 However, this other query works: selec…

Problem with SQL query and parameters

ScottR June 3, 2022, 12:16pm 2

@andrea_bluelabs
What db are you using and can you share a screenshot to show what '%{{ accountIdInput.value }}%' looks like in the first and third query?

Can't refresh pie chart on date range change

Topic		Replies	Views
Variable in SQL 💬 App Building javascript , dropdown , component	3	2904	August 2, 2023
Bind message supplies 2 parameters, but prepared statement "" requires 1 💬 Queries and Resources	2	4148	July 24, 2023
Query with variable not prepared 💬 Queries and Resources	2	1999	August 2, 2023
Bind message supplies 4 parameters, but prepared statement "" requires 6 💬 Queries and Resources	1	349	November 16, 2024
Problem with multiselect fields and get data from DB 💬 App Building	8	518	October 9, 2023

Problem with SQL query and parameters

Related topics