[thelist] Double recordsets in ASP??

[Anthony Baratta]

At 03:20 AM 6/27/2002, Steve Cook wrote:

>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?

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

Set objDBConn = NewDBConn()

strQuery = "blah blah blah blah"
Set objRS_1 = objDBConn.Execute(strQuery)

strQuery = "blah blah blah blah"
Set objRS_2 = objDBConn.Execute(strQuery)

''''''''''''''''''''''''''''''''''''''''''''''''''
'' NewDBConn Function
'' Required Info Passed to Function:
''      None
''''''''''''''''''''''''''''''''''''''''''''''''''
Function NewDBConn()
     Set objNewDBConn = Server.CreateObject("ADODB.Connection")
     objNewDBConn.Open(DB_Connect_String)
     Set NewDBConn = objNewDBConn
     Set objNewDBConn = Nothing
End Function

--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."