[thelist] Double recordsets in ASP??

Anthony Baratta Anthony at Baratta.com
Thu Jun 27 12:51:01 CDT 2002

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")
     Set NewDBConn = objNewDBConn
     Set objNewDBConn = Nothing
End Function

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list