Hi Group,
I'm hoping someone will be able to help.

I am using the following code to output an array of data. However for every row and column, the FIRST item in the arrayed is being output.
I've debugged and inspected the irows and icols variables, and these are correct.

Set rst = objConn.Execute(SQL)
If Not rst.EOF Then

arrData = rst.GetRows()
rst.Close
set rst=nothing

irows = UBound( arrData, 2 )
icols = UBound( arrData, 1 )

redim flippedResults(irows,icols)
for i = 0 to irows
for j = 0 to icols
flippedResults(i,j) = arrData (j,i)
next
next

I guess you are trying to print the values in flippedResults? You can try and print the arrData first and see what happens.

You showed the code for building your array, but not any of the code for your output.

Since you're asking for help with the output, why not post your code for the output? Perhaps that's where the problem is.

Tim

this might be your problem here....

redim flippedResults(irows,icols)

from memory you can only redim the last dimension in a multi dimension array...

So you icols redim works but not your iRows....

As another question.... why flip the array?

That is correct, you can only redim the last dimension of the array.Instead of redim use the following:

Dim flippedResults(irows,icols)