sql recordset into javascript array

hello,
Can someone help with this
I have query result recordset.

1. I have the recordset ok and can get the data from it but I want to put data into a Javascript array?
2. How do I get the numberOfRows?
3. How do I get the numberOfColumns?

If this is related to the ActiveX example you posted previously, does the data get inserted into your array correctly? The array has to be a 2 dimensional array. I.e. -

myArray =
[ ["row 0 col 0", "col 1"],
["row 1 col 0", "col 1"]]

You can use the length property of an array to work out how many rows and columns you have.

http://www.devguru.com/Technologies/Ecmascript/Quickref/array.html