Hi,
I was wondering if you can use tokens in SQL driven options. The manual is a little bit unclear regarding this issue.
For example: I have a table called MyTable with a id, title and username field. In my dynamic form I have a hidden field called Username that maps the Username DNN core value.
My SQL looks like:
select title as QuestionOption, id as QuestionOptionValue from MyTable where username = '$(Username)'
This results in an empty result when testing the query. However the manual suggests this should work on page 76 with Select Text as QuestionOption, Text as QuestionOptionValue from YourTable where Language =
'$(CurrentLanguage)'
Regards,
Tijn