Classic ASP Discussion - Many select statements

Print Page | Close Window

Many select statements

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5564
Printed Date: 30 March 2026 at 11:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Many select statements

Posted By: group1
Subject: Many select statements
Date Posted: 06 September 2003 at 1:14am

Hey i want to execute about 5 different select statements against my access database using asp

I have looked everywhere on the net for a simple solution but they are all so complicated.

Any body got just some simple example code?
or a link to some?

Replies:

Posted By: b_bonnett
Date Posted: 06 September 2003 at 3:59am

strConnection = "(Connection String)"
Set rstData = Server.CreateObject("ADODB.Recordset")
strSQL = "(Select Statement #1)"
rstData.Open strSQL, strConnection
arrData1 = rstData.GetRows
rstData.Close
strSQL = "(Select Statement #2)"
rstData.Open strSQL, strConnection
arrData2 = rstData.GetRows
rstData.Close
etc...

Thats about as simply as you'll be able to do multiple queries with Access AFAIK.

Blair

-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch

Posted By: MorningZ
Date Posted: 06 September 2003 at 8:37am

group1 wrote:

Hey i want to execute about 5 different select statements against my access database using asp

I have looked everywhere on the net for a simple solution but they are all so complicated.

so you expect a 5 select statement piece of code to NOT be complicated??

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: pmormr
Date Posted: 06 September 2003 at 6:12pm

why would you need 5 different select statements anyway

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/