Populating an array from an SQL statement or a Query

[xhonzi]

I'm having a terrible time with this:
I want to execute a loop of code on a series of values.
These values are available through some SQL that is generated by another part of the script.

Anyways, I was looking into the For Each .. Next loop and found that it can either use collections or arrays. So, I want to populate my array with these aforementioned values and then do a for each .. next loop on them. I have tried lots of different combinations but I cannot successfully get my array to populate correctly. There has to be an easy way of doing this. Either from the direct SQL or from a query that I can create and store based on the same SQL.

Any help?

Xhonzi

 

[VBslammer]

Look at the GetRows() method of Recordset object, which can be used to populate an array.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[xhonzi]

Thank you, I have been looking at that method all day. I can't seem to get that, or anything else, to work.

Xhonzi

 

[xhonzi]

Nevermind. I got it working now.