Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
7 years ago

how to get DB table into a 2D array

Hi, I'm trying to fetch the contnts of a DB table into an array then iterating over the array to read the elements.   the DB table has 10 rows and 4 columns, but in the code below: elementList[0,0...
Adagio's avatar
Adagio
Frequent Contributor

Thank you Robert! It helps but problem is still not solved.

This time, I have one whole row of the table going in each element of the array i.e.

 

elementList[0][0] = FirstRow
elementList[1][0] = SecondRow
elementList[1][0] = ThirdRow

 and each cell of that row is separated by ',' . Still trying to get a 2d array like structure in the result.

 

Thank you

Abhi

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

Something is wrong in your implementation.  Please make sure that you have all the code changes I included.  In my tests, what I posted works as desired.  

 

The important piece is here

 

  elementList.push([
     set.Fields.Item("Col1").Value 
    ,set.Fields.Item("Col2").Value
    ,set.Fields.Item("Col3").Value 
    ,set.Fields.Item("Col4").Value] 
    );
    set.MoveNext();
  }

Note the square brackets within the "push" call.  If you don't have those, you won't get the desired nested array.  Please double check this.