load recordset values into array

[mihalych]

Can somebody help me. How can I load recordset values( product id's) into array. I want to pass array (id values) to another page.

 

[100dtl]

sql = "select * from wherever"
set rs = dbobj.Execute (sql)
arrRS = rs.GetRows()

For i = 0 to UBound(arrRS,2)
Response.write &quot;<BR>&quot;&arrRS(1,i)&&quot;,&quot;&arrRS(2,i)
next

..etc

 

[mihalych]

thanks for that
how can I specify in rs.GetRows() to load only &quot;ProductCode&quot; field?

 

[Veep]

Select ProductCode From Wherever

 

[mihalych]

How can I pass array to another page?

 

[shaddow]

Store it to session.
first page

Session(&quot;storedArray&quot=myArray

other pages

myArray=Session(&quot;storedArray&quot

________
George, M

 

[100dtl]

star it if it was helpful