Queries and Session Variables

jmurrayhead · #1 (**permalink**) 05-29-04, 23:46

Hello,

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?

Thanks

ASP-Hosting.ca · #2 (**permalink**) 05-30-04, 18:25

If you want to search a database on the server you need to send request to the server, hence your visitors have to click a button or link to trigger the search.

You can use Session vars in your queries like this:

Code:

sSQL = "SELECT * FROM Users WHERE ID = " & Session("UserID")

jmurrayhead · #3 (**permalink**) 05-30-04, 20:14

That gives me this error message:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression '='.

/mygrade_interface/Results/grades.asp, line 18

ASP-Hosting.ca · #4 (**permalink**) 05-30-04, 20:33

This means your Session variable is empty.

jmurrayhead · #5 (**permalink**) 05-30-04, 20:53

That's what I originally thought, but if I do this:

Code:

<%=Session(appName&"UserName")%>

It will write that value to the page just fine. Any other ideas?

Thanks

rokslide · #6 (**permalink**) 05-30-04, 22:37

so you code currently looks like this...

Code:

sSQL = "SELECT * FROM Users WHERE ID = " & Session(appName&"UserName")

Yes?

jmurrayhead · #7 (**permalink**) 05-31-04, 00:05

I modified the code to look like this and now it works:

Code:

<%
Dim VarSession
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
%>

Internet Services

Web Development

Digital Marketing

Consumer Tech