Is there a way to use session variables in a SQL Driven Option? For example:

SELECT CourseID as QuestionOptionValue, CourseName as QuestionOption FROM StudentCourses WHERE UserID=@UserID AND Term=@Term

The UserID would come from DNN default values or from a session variable, and the Term comes from the Session variables. If this is not possible, would it be difficult to modify the code to do so?

Thanks,

Ben

Hi Chad:

I work with Ben and I am having some trouble getting the $(UserId) to work...specifically, I am using this SQL in the question options section (w/Sql Driven Options selected) to populate options:

SELECT DisplayName AS QuestionOption, DisplayName AS QuestionValue FROM Cleopatra_Courses WHERE UserID = $(UserID)

The query works w/o the where clause, but when I add it...it doesn't work.  From your earlier post, it was my understanding that to get the user id of the person entering page, we filter on $(UserID).

What am I missing?

Thanks!

Hi Chad:

Thanks for the speedy response!

I tried that...specifically:

SELECT DisplayName AS QuestionOption, DisplayName AS QuestionValue FROM Cleopatra_Courses WHERE UserID = '$(UserID)'

Nothing came up...its my understanding that $UserID maps to the dot net nuke user information object (i.e. attached to the user who just opened this page)? 

Or do we need to create a text box (hidden) to capture this value (i.e. we did this with the username value in the "Advanced Field Options" under the sql driver option controls and the user name appeared...but we couldn't get the sql statement to recognize this value)?

Thanks!

Will do and thanks!

I also need the ability to specify parameterized SQL in SQL Driven options. Please could I receive the patch?