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

[Adriano Castro]

    Not directly related to this topic but, since it's a function being
used it's as good place as any to ask this.

    Why does:

        sql_OfficeList = "SELECT office FROM offices ORDER BY office ASC"
        set rs_OfficeList = conn.execute(sql_OfficeList)
        rs_OfficeList_array = rs_OfficeList.GetRows()

    return a _bidimensional_ array where the first dimension has a size of
0 (zero).

    Sorry if it's obvious and the question is dumb. But I don't really
understand why.

    AD

> AD said:
>
>     After reading (1) http://adopenstatic.com/faq/jetcursortypes.asp I
> asked myself which is the most appropriate cursor to use taking into
> consideration that before paging through a recordset I first want to
> count the number of entries on it.
>
> (...)