Faking Database Session State w/ Web Applications


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Faking Database Session State w/ Web Applications

  1. #1
    Jeff Armbruster Guest

    Faking Database Session State w/ Web Applications


    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

    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: Faking Database Session State w/ Web Applications


    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
    >


    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center