[thelist] Double recordsets in ASP??

Steve Cook steve.cook at evitbe.com
Thu Jun 27 10:20:02 CDT 2002

I have an SQL query that returns two separate resultsets (this is a simple

select 1 as result
select 2 as result

Running this query in Query Analyser gives two separate sets of results with
a column called "result" containing the value 1.

Trying this in ASP and procesing through the recordset I'm only getting a
single answer. I'm sure that I have seen a way of extracting both results
from the recordset before. Can anyone point me in the right direction?



 Cookstour - http://cookstour.org

More information about the thelist mailing list