On Fri, 10 May 2002, Gading wrote: > I haven't look this 'paging' seriously, but soon i'll facing this > problem anyway. > > I have a question, when using taglib solution, is it depends on the > Database (ie. support for limit or max rows) and JDBC drive (ie. > support caching ang client side cursor)? In other word, will these > taglib will work with all Database (even when DB doesn't support above > requirements?) Thanks.
Yes. This is one of the major advantages of using JSTL's (or DBTags's) database support. The "LIMIT" and "OFFSET" keywords aren't standard SQL, so using them can limit the portability of your application (and simply won't work if your database doesn't support them). On the other hand, when you use JSTL's <c:forEach> to page through results, or even using JSTL's <sql:query> with its 'startRow' and 'maxRows' attributes, JSTL takes care of the problem for you, and it is possible to write pages that are portable across different databases. -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
