Survey Forums
HomeHomeSurvey Project ...Survey Project ...Using Survey & ...Using Survey & ...Could I put session variable in Sql based answer types? Could I put session variable in Sql based answer types?
Previous
 
Next
New Post
1/18/2016 8:59 AM
 
User is offline linstar4067
No Ranking

Joined: 1/18/2016
Posts: 9

When I add answer type and using sql query for data source , I couldn't put session variable in WHERE clause in sql query.

I try this:

select customerid, customername from tbcustomer where country = @@country@@

But no use.

How could I solve the problem?
 
New Post
1/22/2016 12:44 PM
 
User is offline host
1st Level Poster

Joined: 4/7/2008
Posts: 265

Hello,

The solution is to use quotation marks on the session variable (country is a textfield):

select customerid, customername from vts_tbcustomer where country = '@@country@@'

Also make sure to use the correct table name: vts_tbcustomer


Kind regards,
Survey™ Project Coordinator


SP Community: http://www.surveyproject.org
SP Sources & Downloads: https://github.com/surveyproject
SP Test & Demo: http://www.surveyproject.net
SP Founder: http://www.w3devpro.com
 
 Page 1 of 1
Previous
 
Next
HomeHomeSurvey Project ...Survey Project ...Using Survey & ...Using Survey & ...Could I put session variable in Sql based answer types? Could I put session variable in Sql based answer types?