Solved

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

Posted on 2012-03-22
11
296 Views
Last Modified: 2012-06-21
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 :/
0
Comment
Question by:dashifire
  • 5
  • 4
  • 2
11 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37753965
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.
0
 

Author Comment

by:dashifire
ID: 37753989
that's what i need to know how to do, get the variable
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37753997
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
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37754000
What kind of database are you using?
0
 

Author Comment

by:dashifire
ID: 37754003
MS SQL
0
 

Author Comment

by:dashifire
ID: 37754046
sweet resources btw.
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37754073
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
0
 
LVL 6

Accepted Solution

by:
worthyking1 earned 500 total points
ID: 37760824
In VB you do not have to dim your vars unless you have Option Explicit ON. Personally I never use it. I just pay attention to my vars and make sure I don't use the same name twice.

Not sure how much code you have versus what you're showing us, but you're missing some  basics so here's how I would do it...

SQL_Conn_STRING = "Driver={SQL Server};Server=MyServerName;Database=MyDBName;uid=MyUsername;pwd=MyPassword"
Set Con = Server.CreateObject("Adodb.Connection")
Con.Open SQL_Conn_STRING

set rs  = Con.Execute("SELECT Top1 EmailAddress FROM USERS WHERE UserID='"&session("userid")&"'")	
If NOT rs.EOF then
      paypalnew = Trim(rs("EmailAddress"))
      session("paypalemail")=paypalnew
Else
      ' No user found with this UserID
End if

Open in new window

0
 

Author Comment

by:dashifire
ID: 37760926
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.
0
 
LVL 6

Expert Comment

by:worthyking1
ID: 37761160
Then just make sure to dim all your variables first before you use them.
0
 

Author Comment

by:dashifire
ID: 37772185
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!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question