Hmmm...this is one of the most frequently asked for options on the JSP-Interest mailing list. You'd think there would be an option like this in the Jakarta taglibs. Is there a way to do this in JSTL 1.0? If not, could this be in JSTL 1.1?
Steve > -----Original Message----- > From: Modha Kumar [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 5:44 PM > To: Tag Libraries Users List > Subject: RE: How to split results over multiple pages with DBtags ? > > > use http://jsptags.com/tags/navigation/pager/ > > > -----Original Message----- > From: Soefara Redzuan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 5:34 PM > To: [EMAIL PROTECTED] > Subject: Re: How to split results over multiple pages with DBtags ? > > > >From: peter lin <[EMAIL PROTECTED]> > > > >The proper way to do this is to only return n number of > rows. Typically > >this is done with scrollable cursors. The driver you're using has to > >support the feature. I don't see support for it in dbtags, > so your other > >option is to use stored procedures or prepared statements that handle > >the cursor yourself. > > If DBTags does not support this, how are other people doing > this ? This is a > basic functionality that I believe everybody uses. I think I > will have to > write a scriptlet if DBTags does not have it. > > >fetching tons of rows to only display 20 will limit the > scalability of > >your web application under load. > > That is what I thought. > > >Especially if your database server isn't beefy :) > > In actual fact I thought it is more of a problem with all the > records being > transfered over the network unnecessarily. > > Thank you for your help Peter. > > Soefara Redzuan. > > > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>