[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
example)

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?

Cheers!

.steve


----------------------------------
 Cookstour - http://cookstour.org
----------------------------------



More information about the thelist mailing list