Server Variables ? 2

[JimFlower]

I have the following code

dim xxx
xxx = Request.ServerVariables("Logon_User&quot
fp_sQry="SELECT * FROM Results Where User ='" & xxx & "'"

and its not working

fp_sQry="SELECT * FROM Results Where User ='Jim'"

This does work so the value of xxx must not be right
How do I view xxx and what else can I do?

 

[Palooka]

You could try debugging by printing it's value on the web-page:

Respone.Write("Value of xxx: " & xxx)
Response.End

Palooka

 

[sinead123]

You may want to try adding the following after the dim statement.

response.write "User = " & Request.ServerVariables("Logon_User")

This will write out the value of the Logon_User servervariable.