You could try doing your loop and load the results into an array:
Dim arrNew
for i = 1 to 12
strSQL = "SELECT * from myTable WHERE some condition"
set rst = dbConnection.execute(strSQL)
arrNew[i] = rst
next
or use a 2 dimensional array if you are returning more than one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.