Type Mismatch error - why?

[JanS]

Hi,

When I run the following code I get this error:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rsCustomerList'

Any ideas what I am doing wrong? I am trying to load data from a recordset into an array.

Thanks
Jan

<%
dim my_array()
dim i
i = 1

rsCustomersList.movefirst
do until rsCustomersList.EOF
redim preserve my_array(i)
my_array(i) = (rsCustomerList(&quot;Report_Name&quot)
rsCustomersList.movenext
i = i + 1
loop
%>

 

[JanS]

dont worry - Ive worked it out - if only I could type

thanks anyway
jan