Hi All,

How do I put my recordset into an Array? If the "do while" does not work, can I use the "for....loop?" If so, how do I do so? Please read my current codes below. IT DOES NOT WORK!
When i code in MyArray=rsCategory("QueryCategory") to try to get the values into the array, I get an error message.

'Get recordset
set rsCategory=Server.CreateObject("ADODB.recordset")
SQL1="SELECT sCategory, sDescription, sValue, menu1relation, QueryCategory FROM sCategory where sCategory= '" & sCategory & "'"
rsCategory.Open SQL1, sConnection

Dim MyArray
MyArray = array()
do while NOT rsCategory.EOF
   MyArray=rsCategory("QueryCategory")
rsCategory.movenext
loop

Thank you for all your help!

Leon

Hi there,

You're not actually putting your records in an array, you are assigning the value from the recordset to a variable. So, at this point:

MyArray = rsCategory("QueryCategory")

the variable MyArray holds just the name of one category. After the next loop, it holds the name of the next category.

You could create an array and use an indexer / loopcounter to store the results (e.g. MyArray(i) = rsCategory("QueryCategory")), but I think you're much better off using the build-in GetRows method, like this:

MyArray = rsCategory.GetRows()

Check out this page for more info: http://msdn.microsoft.com/library/de...mthgetrows.asp

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

This solution helps! Thanks again Imar!

Leon