[thelist] Double recordsets in ASP??

Amazon Paulo Amazon.Paulo at Amazoniacelular.com.br
Thu Jun 27 16:06:01 CDT 2002

>You need Two Record Sets. Each Query is an independent operation. You are
>overwriting the first query results with the second.

The RecordSet object has a method called NextRecordSet, so you won't need
two recordsets. To get more than one recordset at a time, open it using
semicolon, like this:

Set rs = conn.execute "Select * from pubs; Select * from news"

You can check for more information on msdn:

/Paulo Guedes

More information about the thelist mailing list