I.T. Discussion Community!
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

November Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyASP Classic Coding BoardASP Classic Coding Topic   Print This     

ASP query

ASP query in ASP Classic Coding topic (part of our ASP Classic Coding group).

Quick Search: ASP query  
aka51
MD

I am submitting a query in an ASP page.

It is a tow piece query and I am not sure the correct process to accomplish this.
First I am

 
SQL ="SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &";"

then the valuse returned from this query i would like to use it in the next query

 
SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 = (tring to use the value from the previous query here)"

I tried to combine the select statement as below


 
SQL ="SELECT aoemail, aofirstname, aolastname FROM tblAO where OAID1 =

(SELECT OAID1 FROM tblOrganization where branch_labid = "& Request("branch_labid") &" ); "

but I get the
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Can anyone offer some help.

Peace love and happiness
 Posted 17 years ago (Thread Starter)
Comment Quote
About aka51 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8142, 1 replies
Thread Started 11/1/2002 6:42:00 AM
View Counter=3442
Last Reply Posted 4/24/2008 5:20:15 PM)
Location=MD  
Joined=17 years ago   MB Posts=25  
Most Recent Post
ParaDelphi
-- USA
How did you solve this? Was it with the in keyword?

----
Paul "The Coder" Santoro

 Posted 11 years ago
Comment Quote
About ParaDelphi -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About ParaDelphi

Paul has been developing in paradox and delphi since the mid 90s.


Post ID #12704 (Level 1.1)  Reply to 8142
Thread Started 4/24/2008 5:20:15 PM
Location=-- USA 
Joined=12 years ago   MB Posts=23   KB Comments=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #8142 Counter
3442
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech