Forum Academy Marketplace Showcase Pricing Features

SQL Connector: Insert using Parameter

Using SQL Connector to AWS MS SQL. Insert statement inserts parameter number ($1 inserts a 1 into the table instead of the value of parameter $1).

what am I doing wrong?

This happens when I initialize or update the query through the connector, or use as an action through the application. I also verified by adding a second parameter and using it. In that case it inserted a 2 to the table when referencing $2. The field type in the table is varchar(50.)

Found the answer here: Not able to define SQL parameter on bubble - SQL query for dynamic search (multiple optional parameters)

MS SQL insert state uses @Paremetername to call the parameter… so correct syntax:
Insert into Uname
Values @name;