Groups | Blog | Home
all groups > inetserver asp db > february 2006 >

inetserver asp db : Read a recordset into a variable so I can disconnect from DB and use results?



Noozer
2/6/2006 12:00:00 AM
This seem to be a simple question, but I'm having no luck with Google
keywords...

I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.

Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?


Noozer
2/6/2006 12:00:00 AM

[quoted text, click to view]

Doh!

As expected... As soon as I post my question I find my answer!

Use the GetRows function of the RecordSet.... It returns a two dimensional
array of rows and columns.

AddThis Social Bookmark Button