Use Table Cell Value in Query Where Clause

[haj]

I am trying to use the value of a table cell in a WHERE clause:

SELECT SUM("invoiceTotal") AS lines_total, SUM("balanceOwed") AS lines_balance FROM "invoicesToCustomer" WHERE "invoiceNumber" = '{{invoicesTable.selectedRow.invoiceNumber}}'

I get the error:

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

I know this is a simple problem, but Googling and the Forum didn't reveal an answer.

Thanks.

[haj]

I found the solution, although I don't understand why.

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…

[haj]

So, the correct query is:

SELECT SUM("invoiceTotal") AS lines_total, SUM("balanceOwed") AS lines_balance FROM "invoicesToCustomer" WHERE "invoiceNumber" LIKE {{'%' + invoicesTable.selectedRow.invoiceNumber + '%'}};

[PatrickMast]

Hello @haj,

Just curious, does this also work:

SELECT SUM("invoiceTotal") AS lines_total, SUM("balanceOwed") AS lines_balance FROM "invoicesToCustomer" WHERE "invoiceNumber" LIKE "%{{invoicesTable.selectedRow.invoiceNumber}}%";

Patrick

[mbruijnpff]

@PatrickMast , no that won’t work, the part between {{}} is already being converted to a string with surrounding double quotes. The result would be “%”string”%”.
The way @haj did it is indeed the correct way to do this.

[haj]

@PatrickMast. I tried your way first. @mbruijnpff is correct. Won't work.