Can session variables be used in a query somehow? I my users to be able to click on a link, and from there the query would search the database for the value stored in the variable, (their username, for example), and then display those results. I don't want the users to have to click on a submit button or anything, just automatically search the database for their username via the session variable....or does anybody have an alternate suggestion?
I modified the code to look like this and now it works:
VarSession = Session(appName&"UserName")
strQuery = "SELECT * FROM Results Where StudentID = '" & VarSession & "' ORDER BY StudentLastName ASC,StudentFirstName ASC"
Set rsGradeData = Conn.Execute(strQuery)
If Not rsGradeData.BOF Then