At 12:12 AM 5/10/2002 -0400, you wrote: >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.
Will it scalable and efficient to handle thousands of records? Thanks for your reply. Btw, books from manning is not very common in here (indonesia, but wrox does), is it "good" ? :-) >-- >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
