Have a look at http://displaytag.sourceforge.net/
Paul > -----Original Message----- > From: Manisha Sathe [mailto:[EMAIL PROTECTED] > Sent: 18 January 2005 09:34 > To: Struts Users Mailing List > Subject: Re: How to limit the result? > > > After long search i found out that MSSQL does not support > Limit / range of records to be fetched. > > Now i am thinking -> > 1)putting each row into one databean. > 2)Put databean into ArrayList > 3)send this arraylist back to JSP > > with jstl tags i can loop through it and display. > <c:foreach>...<c:out> > > But how i can decide it has reached page limit ? because at > that point of time i want to display my footer (and header > for new set). > > Is there any way to set some variable and keep on > incrementing it .. check for pagesize and then include > header/footer etc... > > Is there any better solution ? Am i going a long way ? > > regards > Manisha > > > > > > Manisha Sathe <[EMAIL PROTECTED]> wrote: > I have a query which results into large data. This data i > want to display in a group of 20. After every 20 records i > want to add header and footer to it. > > Is it possible to get the result set data into batch of 20 ? > means can i specify start and end index of query ? > > regards > Manisha > > > > --------------------------------- > Do you Yahoo!? > The all-new My Yahoo! - What will yours do? > > --------------------------------- > Do you Yahoo!? > The all-new My Yahoo! - Get yours free! > Axios Email Confidentiality Footer Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message, and notify us immediately. If you or your employer does not consent to Internet email messages of this kind, please advise us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my Company or employer unless otherwise indicated by an authorised representative independent of this message. WARNING: While Axios Systems Ltd takes steps to prevent computer viruses from being transmitted via electronic mail attachments we cannot guarantee that attachments do not contain computer virus code. You are therefore strongly advised to undertake anti virus checks prior to accessing the attachment to this electronic mail. Axios Systems Ltd grants no warranties regarding performance use or quality of any attachment and undertakes no liability for loss or damage howsoever caused. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
