Hi,
I have a MySQL database and I am not able to define different parameter values in my SQL query on bubble. Because of this I am not able to write a dynamic search query in SQL that will allow users to search on my website. Bubble only accepts ? as the parameter value in the query. @ParameterName is not accepted as a parameter value in SQL query in bubble. This type of parameter naming is accepted everywhere else except bubble. Is it just me or this is the way bubble works?
If it’s the normal way of processing SQL queries in Bubble can someone please tell me how do I write a dynamic search query by using only ? as a parameter value for all parameters?
Thanks a lot.
Below given query format is the only query format that works in Bubble:
@NigelG@mishav@emmanuel
Could you please help me solve this error? I would really appreciate some help on this. My project is stuck because bubble doesn’t read parameters that are named starting @parametername or $parametername. Is there any other definitive way of naming a parameter other than by ?
I think that this is DBMS related and that query string is sent to the server as it is. In query string, parameters can be ? (in this case the order is important), $n (wnere n is 1, 2 …) or @paramname. The last format works with MS SQL Server.
You should provide test values for the parameters, which are used when you initialize the query. Maybe this is the reason that nothing works in your setup as in picture.
I would like to know what exactly to what extent the dynamic parameters can be used. I first assumed that it can make the entire query a dynamic value, which would be amazing, but now I see that it is very limited. Now I would like to know exactly the limits and how they should be used
Try Postgres documentation. This limitation is pretty standard across SQL interfaces for queries and parameter binding, its not a Bubble-specific limitation.
The way Bubble has implemented it is that a query is predefined, and parameters (dynamic or static) are bound to the query by placeholders in the query. This setup is pretty safe from SQL injection attacks, but it doesn’t give us flexibility in programmatically constructing queries.
If you need more flexibility, perhaps look into the options you do have, such as conditional values, views, joins, and you can even have different queries setup inside a stored procedure.
@mishav could you please help to figure out the following:
I’m trying to write a query to PostgreSQL and create a table from bubble workflow, and use the table name as for example as bubble’s user name(or ID). But as I understand you can’t do it that way. I google and postgre has a trick to do that, however it feels like bubble doesn’t support
plpgsql syntax.
Here is what I found:
they use the format() function. But the thing is that I can’t pass parameter from bubble ($1… $n) into query. I’m keep getting an error:
(I am using postgres if that matters)