Solved

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

Posted on 2012-03-22
11
295 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now