Subscript out of range

LAYGO · December 17th, 2009, 03:54 PM

I can't figure this one out.

I run a query, use getRows & assign it a variable name. I've run the query, see that it ONLY RETURNS 1 row. The array ubound is as expected (0).

Code:

If NOT (recordSet.BOF AND recordSet.EOF) Then
    myGetRowsArray = recordSet.GetRows
End If

Response.Write TypeName(myGetRowsArray) & " - " & UBound(myGetRowsArray)

Result in: Variant() - 0

If I try to look at the value: myGetRowsArray(0)

I get subscript out of range! WUTFUX?!?

LAYGO · December 17th, 2009, 03:59 PM

Turns out it's coming back as 2D array: UBound(myGetRowsArray,2)

OOPS! :)