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

[Adriano Castro]

    Hi Joshua,

> Joshua said:
>
> For recordset pagination, I suggest *highly* that you look at the
> following
> article:
>
> http://www.15seconds.com/issue/010308.htm
>
> It outlines a couple different approaches to working with paginated
> recordsets.  Solution #3 uses none of the native ADO implementation to
> facilitate paging and in my experience the method blows the doors off the
> other methods.  It's fast, scalable, and very stable.
> (...)

    The article seems quite good but there are some slight details about
it that have made question the efficiency of the paging and counting
when compared to the article that I mentioned earlier.

    Solutions 1 and 2 on the 15seconds.com article require an adOpenStatic
cursor since they use the RecordCount. Also, solution 3 won't work for
me since I'm using Access (or am I'm bluntly wrong?).


>>     Also, if all I want to do is check if the recordset returns anything
>> is "IF (recordset.EOF) THEN do_something END IF" the best thing to do?
>
> Generally you'd want to check that both EOF and BOF are true.

    Thanks for that correction.

    AD

P.S. - I'm sorry for my duplicate emails but my webmail's constantly
returning an error when submitting the replies when, after all it is
delivering the emails.