[thelist] conserving resources - closing a recordset in ASP

[Wade Armstrong]

On 9/22/03 Sarah Sweeney <ssweeney at w3internet.com> wrote:

>I am trying to make my ASP code a little easier to write, and read, by 
>creating a function to perform a query for me and return a recordset. 
>Here 
>is the function:
>   function doQuery(sql)
>   {
>     var rs = Server.CreateObject("ADODB.Recordset");
>     rs.Open(sql,conn,adOpenStatic);
>     return rs;
>   }
>Of course, using this function means that the recordset doesn't get 
>closed. 

How about:

  function doQuery(sql)
  {
    var rs = Server.CreateObject("ADODB.Recordset");
    rs.Open(sql,conn,adOpenStatic);
    var myArr = rs.GetRows()
    rs.Close
    rs = null
    return myArr;
  }
  
That will leave you with a nice, handy two-dimensional array of your
query results, through which you can iterate without having to carry an
object around.

Wade