calling session variables within query

[ifntech]

What is the syntax to call a session variable within a query within ASP.NET?

Trying something like this (Request is not working)

<script>
Dim Var1 AS String
Var1 = Session("Varone")
Session["Varone"] = "apples";

</script>

The query

SELECT test.field1
FROM testtable
WHERE navigation.var1 = N'<%=Request.session(varone) %>'

 

[jbenson001]

Put the session variable delcaration in the code behind.

Dim Var1 AS String
Var1 = Session("Varone")
Session["Varone"] = "apples";


Then do your select (in the code behind)
SELECT test.field1
FROM testtable
WHERE navigation.var1 = Session("varone");