I have a problem in that I am trying to update a password based on an email address obtained from a querystring. I need to put the querystring value in a session variable due to some different scenarios. Everything works perfectly with a standard email address: bob@outlook.com
, but if I use the '+' symbol in the email address like bob+1@outlook.com
the session value shows a space where it should show a '+' symbol. This causes my SQL to fail to find a match.
When I create a test session variable such as session("plus") = '+'
this works perfectly. However session("email") = request("email")
will convert the '+' to a space.
If Request("email") <> "" Then
Session("email") = Request("email")
Session("DBstatus") = "Password Reset Requested"
End If
I expect this: session("email") = "bob+1@outlook.com"
I get this: session("email") = "bob 1@outlook.com"
I have tried using server.urlencode
but that does not match the value stored in my tables.