Store SQL Server result set into an array with ASP 3.0

Question

My ASP knowledge is shaky--I haven't used it regularly in years. I'm working with an ASP application. It performs a basic search, returning multiple columns and rows:

rs = conn.execute("SELECT col1, col2, col3, col4, col5, col6, etc. FROM some tables")
While Not rs.EOF
   Response.Write rs("col1")
   Response.Write rs("col2")
   etc.
 Wend

The users are going to start using a new application, and I have a separate query which will retrieve those results. But, I want to put all the results in an array so all the results that are displayed look normal (no extra sections, forms, etc.). I figured by combining both arrays, I could accomplish this. I just don't know how to put the results into an array. Thanks!