Loading a bi-dimensional array and RS(s)
Posted on 2001-08-06
I have an array containing a list of product IDs related to a certain user.
Dim counter As Integer
counter = 0
For counter = LBound(arryID) To UBound(arryID)
arryID is the array containing the IDs.
What I would need is the following:
within the loop of the array -- x each element of the array -- I need to launch n SELECT(s)of this kind: select from mytable where ProductID = ID.
Then I need to load a bi-dimensional array where the 1 dimension is (one of) the ID on the basis of which I am doing the SELECT , and the 2 dimension is a string of all the exixting values in the DB for that ID chained by a comma.