session variables in sql statement

[frogggg]

what's wrong with this code?

rsDisplay.setSQLText("SELECT JobInfo.* " _
& "FROM JobInfo " _
& "WHERE Location=" & session("Location&quot)

I'm getting this error:

Too few parameters. Expected 2.

When I put the single quotes in I get data type mismatch, because a number is being passed.

Is there something I don't know about session variables in sql statements?

 

[Nagrom]

You might want to throw in some debug code to ensure that Session("Location&quot actually has a value. If the client you are hitting it with doesn't have Session level cookies enabled then the server won't "hold" that Session variable and it will be empty everytime you hit it from a new page.

 

[cfk]

I'm guessing your using as access database.
When you get this sort of sql error is
can often mean you have an unquoted string.
Try

rsDisplay.setSQLText("SELECT JobInfo.* " _
& "FROM JobInfo " _
& "WHERE Location='" & session("Location&quot & "'&quot

note the single quotes