SQL recordset to ASP array

[learner45]

Hi,

I have a recordset containing 2 fields; i.e. Item_ID and Item_Name. The recordset is named rsOrders. What I would like to do is to save the recordset rows into an array of huperlinks - something like this:

varOrder() = "<th><a href="?itemid=<%= rsOrders.Fields.Item(&amp;quot;Item_ID&amp;quot.Value %>"><%= rsOrders.Fields.Item(&amp;quot;Item_Name&amp;quot.Value %></a></th>"

The variables in this array will be available for further use in the same ASP page.

I'm a novice... Thanks for your patience and help!!!

 

[foxbox]

dim i
i = 0
do while not rsOrder.eof
 varOrder(i) = "<th><a href='?itemid=" & _
    rsOrders(0) & "'>" & _
    rsOrders(1) & "</a></th>" 
 i = i + 1
 rsOrders.movenext
loop

(not tested)

 

[ChrisHirst]

Why not just use the getRows() method??

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.