Recordset into an array

Please help me!

[Shuvi]

Does anyone have an example of how to put a rs("name") into an array?
Is this correct?

Dim vebaarray
vebaarray = array(rs("Description"))

And then how do I use it? I want it to appear in a drop down box.
Here's what I've tried.

counter = 0
While counter < count %>
<option value="<%= vebaarray(counter) %>"><%= vebaarray(counter) %> </option><%
counter = counter + 1
wend

Help!

[defanjos]

Look into GetRows.

You can start here:
1 [w3schools.com]
2 [aspfaqs.com]

[mattglet]

<select name = "name">
<%
while not rs.eof
%>
<option value = "<%=rs("description")%>"><%=rs("description")%></option
<%
rs.movenext
wend
%>
</select>

-Matt

[f00sion]

dim alldata
alldata = rs.getrows
numrows = ubound(alldata,2)

for i = 0 to numrows
response.write "<option value=""" & i & """>" & alldata(0,i) & "</option>"
next