I am trying to convert the text value of a series of Query strings sent from Dynamic Forms to the Tailored Text module. I tested the process through a stored procedure in SQL server, but the particular conversion piece is causing the tailored text module to crash, and the entire page fails to load.
What I do is have a query string pass from the Dynamic form into the Tailored Text, $(Ques1). What I want to do is to use the answer (Yes or no) to convert into a 1 or 0 value. So what I did was create SQL token, $(N1) containing the following T-SQL snip:
If $(Ques1) = 'Yes'
BEGIN
SET $(N1) = 1
END
ELSE
BEGIN
SET $(N1) = 0
END
I’m obviously missing an important part of what is needed for this, or maybe trying to set the value of a token based on another token can’t work.
Any thoughts would be greatly appreciated.