multiple RecordSets??

[TheCandyman]

Is it possible to have multiple recordsets like below so i only have to setup a connection to the DB once???

-------------------------------------------------
Dim myConn3,myPath3
Set myConn3 = Server.CreateObject("ADODB.Connection&quot
myPath3 = Server.MapPath("Accessdb/WEBDB.mdb&quot
myConn3.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & myPath3 & " ;"

Dim rs3, mySQL3
Set rs3 = Server.CreateObject("ADODB.RecordSet&quot
mySQL3 = "SELECT * FROM WEBDATA WHERE web_page LIKE '1'
rs3.Open mySQL3, myConn3

Dim rs2, mySQL2
Set rs2 = Server.CreateObject("ADODB.RecordSet&quot
mySQL2 = "SELECT * FROM WEBDATA WHERE web_page LIKE '2'
rs3.Open mySQL2, myConn3

Dim rs, mySQL
Set rs = Server.CreateObject("ADODB.RecordSet&quot
mySQL = "SELECT * FROM WEBDATA WHERE web_page LIKE '3'
rs3.Open mySQL, myConn3


** then close connection and all recordsets....

 

[madhouse]

In short yes, you can open multiple Recordsets.

 

[UkJay1]

Hi CandyMan

Interesting question

Did you try it?

and did it work?

Jay

 

[HowardMarks]

This is perfectly acceptable, apart from you are opening rs3 everytime ( i think this is a typo ).

Nick

Nick (Software Developer)

http://www.retrographics.co.uk

http://www.retrotest.co.uk

nick@retrographics.fsnet.co.uk
nick.price@myenable.com

 

[TheCandyman]

Just so everyone knows, i tried it and it speeds up the final display tables a lot. Can't believe i didn't try or think of this a while ago.

 

[UkJay1]

Thanks for the update

Jay

http://www.ukjay.com

How can I go forward when I don't know which way I'm facing (John Lennon)​