>I need to create a recordset and be able to access it from within several Sub Routines or Functions. What is the best method to do this inside of an .Asp page? Is it a good idea to give recordsets session scope? (I have a VB COM object returning the recordset to the page. The COM object takes an SQL statement as a parameter)


If you only need the recordset in one ASP page, declare the varible outside a sub or function and it's global to the page.

If you need the recordset from more then one ASP page, you can store it in a session variable.