Faking Database Session State w/ Web Applications

[Jeff Armbruster]

I would greatly appreciate your answer to the following question:

I have a table with over 300,000 Products (SKUs). A user browses through
an HTML table of 20 items.
They hit the page down button on the screen to view the next 20 items. What
mechanism in ADO can
I use to keep track of where the user is within their view of the catalog?
Bearing in mind that the
user may have selected one of a variety of filtering options (from the Screen
ap) to look at a catalog
of products.

Thank you.

Jeff Armbruster

[Bill Vaughn]

This is an age-old problem. I discuss solutions to this in my book(s), but
the basics have more to do with how the query is written than setting properties
in ADO. ADO is not the best mechanism for handling this problem--although
many have tried. You'll find that using a TOP query to return the top "n"
rows that meet a criteria is your best bet and when combined with a WHERE
clause that positions you past the last fetched row from the previous query
you should get a reasonable number (not necessarily exactly "n") of hits
back to display. If the rows are indexed, that will help the Where clause
work as expected.
hth

bv

"Jeff Armbruster" <jarmbruster@home.com> wrote:
>
>I would greatly appreciate your answer to the following question:
>
>I have a table with over 300,000 Products (SKUs). A user browses through
>an HTML table of 20 items.
>They hit the page down button on the screen to view the next 20 items. What
>mechanism in ADO can
>I use to keep track of where the user is within their view of the catalog?
>Bearing in mind that the
>user may have selected one of a variety of filtering options (from the Screen
>ap) to look at a catalog
>of products.
>
>Thank you.
>
>Jeff Armbruster
>