> > 4. The user clicks the 'more' button
> > 5. The primary key value of the last row is sent to the server as a
> > parameter.
> > 6. The same query is sent to the server with the following pseudo WHERE
> > clause tacked on the end
> >
> > WHERE primary_key_column > 'primary key value of last row in results'.
This is not really JSP oriented, but a general problem with online system
that uses SQL. The above solution only works if the query is simple enough
that the order of the rows returned also matches the primary_key_column
value. With SQL, once you get into ORDER BY and the like, you are not
likely going to benefit with such a solution. Also, the primary key in many
SQL databases are not classic "sort" keys anyway, since they are unique keys
that are often serial numbers, timestamps or the like. There's a basic
taboo about having primary keys that have semantic meaning rather than just
being unique IDs.
David
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
