Goal: I am trying to consume variables or selected items in a sql query(stored procedure) Steps: I have tried using {{select1.selectedItem.value}}, but running the sql uses '@param1' instead of the value I have tried storing the value in a variable , and running the sql with {{variable1.value}…

@Params in SQL query not working

brian.hickey November 5, 2024, 5:38pm 2

Looks like the N prefix in the query breaks the string interpolation

@PricingProgramName = N{{@param1}} evaluates to N@param1

@PricingProgramName = {{@param1}} evaluates to 'myParam1Value'

Is this expected behavior?

Topic		Replies	Views
Sending parameters to shared SQL query though javascript not working 💬 Queries and Resources bug , javascript , sql	2	1588	August 3, 2023
Variable in SQL 💬 App Building javascript , dropdown , component	3	2894	August 2, 2023
How to pass parameter from Javascript to SQL query? 💬 App Building bug , sql	7	12324	July 27, 2023
Variables as column names 💬 Queries and Resources	4	4108	August 2, 2023
SQL Queries Not Accepting Form Values 💬 App Building	4	332	June 14, 2024