asked on

Need to do an SQL select statement in Classic ASP for a variable

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)"

Open in new window

My code is currently:

dim paypalnew as string = "SELECT EmailAddress FROM USERS WHERE UserID='"&session(userid)&"'"	
session("paypalemail")=paypalnew

Open in new window

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 :/

Paul Jackson

There are no datatypes in VBA other then variants so all variables are just defined like

Dim myVariableName

and to set a value to it :

Set myVariableName = 'whatever'

so your code would become :

dim paypalnew 
set paypalnew = "SELECT EmailAddress FROM USERS WHERE UserID='"&session(userid)&"'"	
session("paypalemail")=paypalnew

Open in new window

However you code will not achieve you desired result (as I understand it) of populating the session variable with the result of the query it will just populate it with the text.

dashifire

ASKER

that's what i need to know how to do, get the variable

Paul Jackson

Here is a good asp resource : http://www.asptutorial.info/

Here is a resource for learning about how to use ADO for connecting to databases using asp :

http://www.w3schools.com/ado/default.asp

Paul Jackson

What kind of database are you using?

dashifire

ASKER

MS SQL

dashifire

ASKER

sweet resources btw.

Paul Jackson

Another nice tutorial here on how to use ado with asp to connect to a sql server database :

http://aspalliance.com/655_Basic_ADO_and_SQL_Tutorial.1

ASKER CERTIFIED SOLUTION

worthyking1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dashifire

ASKER

Thanks when I get a shot next I will try this. I do have option explicit on though, not my idea, but working with it anyway.

worthyking1

Then just make sure to dim all your variables first before you use them.

dashifire

ASKER

That was perfect, the tutorials are terrific, but they don't tell me what is a variable and i was getting confused. I got it up and running now, so it is all good! Thanks Guys!