[thelist] ADO cursor - best solution for count and page throughprocedure

Adriano Castro ad at netvisao.pt
Wed Mar 31 10:34:41 CST 2004


> AD said:
>
>     Correct. But, since it's a bidimensional array that means that
> rs_OfficeList_array(1)(0) should have something in it, right?
>
> UBound(rs_OfficeList_array,1) --> is  (don't really understand why)
> UBound(rs_OfficeList_array,2) --> is 7 (total number of records on table)
>
> but
>
> Response.Write rs_OfficeList_array(0)(0) --> is the 1st record of "office"
> Response.Write rs_OfficeList_array(1)(0) --> is out of range
>
>
>     What's stored on the 1st dimension then?
>     And what's stored on the 2nd dimension?

And Scott Dexter kindly replied:
http://lists.evolt.org/archive/Week-of-Mon-20040329/157229.html

I get it now!... (thanks Scott)

"GetRows() always returns a two dimensional array, even if you're
getting a singular value"

AD


More information about the thelist mailing list