SQL Microsoft SQL Azure problems

I’m doing a SQL query and nothing is show in any text using dynamic insertion. Here’s some pics of my code:
Query code:

SELECT TOP 1 Preço
FROM my_table
WHERE Produto = ‘@PARAMETER1
AND hortifruti = ‘@PARAMETER2
AND Unidade = ‘@PARAMETER3
AND Região = ‘@PARAMETER4
ORDER BY Date DESC;

and using to display it on my page like this:

image

image

Remove the ’ ’ e.g ‘@PARAMETER1’ should be @PARAMETER1 and then you need to add the parameters to the query in the SQL connector as PARAMETER1 with the type defined there. Here is an example from one of my queries:

Finding documentation and even examples for Azure querys is so difficult in Bubble. Now the query works! Thanks a lot!

1 Like