Array and a Recordset Question Hi

[Ecreations]

Array and a Recordset Question
Hi guys
i have a recordset returning one field
I want it to return an array of that field
i know about GetRow but i want to use an array
now i got this far but keep getting errors

Do While Not rs.EOF
ReDim Preserve MyArray(x)
MyArray(x) = rs("Title&quot
rs.MoveNext
x = x + 1
loop

any help would be greatly appreciated

 

[FesterSXS]

what error are you getting?


Tony

http://www.SpiraxSarco.com/cad

 

[simonchristieis]

Are you declaring the var. first?

dim MyArray

Do While Not rs.EOF
ReDim Preserve MyArray(x)
MyArray(x) = rs("Title&quot
rs.MoveNext
x = x + 1
loop

 

[Ecreations]

Thanx for the response guys
it was all of course my fault. i was trying to use the results in a client side javascript thats expecting a string var /DUH/, after afew slaps on the forehead i used the forgotten join function to make the asp array a string and send to the client javascript.
all of that coz Mr nextscape doesnt suport the Marquee and i wanted to make the script compatible on both IE, and Netscape.
the script is actually an asp news scroller



The solution is simple, the problem is complex.

http://www.ecreationscanada.com