Multiple Recordsets (Long Post)

[minoad]

I am about to attempt something i have not done before. I believe the best way will be to use multiple recordsets. my code will look similar too:
dim adors
dim locrs
dim catrs
dim sqlstr
dim locsql
dim catsql

set adors= server.createobject ("adodb.recordset&quot
set locrs= server.createobject ("adodb.recordset&quot
set catrs= server.createobject ("adodb.recordset&quot
set sqlstr= "Select * from ABC where btype=(('" & cat & "')_
and blocation=('" & loc & "'));"
set locsql= "----code to fill drop down form----;"
set catsql= "----code to fill drop down form----;"

adors.open, sqlstr DSN="S215"
locrs.open, locsql DSN="S215"
locrs.open, catsql DSN="S215"

Sorry if any of this seems sophmoric. Just wanted some opinions before i actually ran with this code.
(This code was typed relatively quickly during lunch break so thier may be some syntax errors or spelling mistakes)

 

[smbure]

ADO is straight forward, looks good to me (except for the typos...hehehe)


smbure

 

[Swany]

One thing..

you should create one connection object
set conn = server.createobject("ADODB.connection&quot
conn.open "DSN=S215"

rs.open sql, conn
...

rs.close
conn.close

 

[minoad]

Is a connection object necassary. For whatever reason when i have tried to do that, i get errors stating that the dsn does not exist, but when i switch it to the recordset it works just fine.

Micah A. Norman