I need to replace a session variable with the results of an SQL statement
that statement essentially is:
SELECT EmailAddress FROM USERS WHERE UserID=session(userid)"
My code is currently:
dim paypalnew as string = "SELECT EmailAddress FROM USERS WHERE UserID='"&session(userid)&"'"
However I am getting an error at "as"
I tried doing paypalnew=thestring but it put it as straight text instead of being a SQL Statement.
This is my first real programming project, so i know that i am probably just missing some basics, but finding resources for classic ASP is very tough :/