Assigned session variables to local variables

[Sunil606]

Hello!
Is it possible to assigned session variables to local dim variables. For example


Dim strTech
strTech = Session("Role&quot

It does not work for some reason. Or is it possible for me to utilize session variables in an sql statement??

Thanks in advance

 

[mwa]

This should be Yes and Yes. Yes you can assign them to local variables and Yes you can use them directly in a sql statement. Try this:

<%
session(&quot;string&quot;) = &quot;Hello World&quot;
Response.Write &quot;Session Variable: &quot; & session(&quot;string&quot;)
dim strLocal 
strLocal = session(&quot;string&quot;)
Response.Write &quot;<BR>Local Variable: &quot; & strLocal
dim strSQL
strSQL = &quot;select * from table where column1 = '&quot; & session(&quot;string&quot;) & &quot;'&quot;
Response.Write &quot;<BR>SQL String: &quot; & strSQL
%>

mwa
<><