RE: Paging and Sorting

From: "Chris Bayes" <chris@xxxxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE:  Paging and Sorting
Date: Mon, 8 Oct 2001 16:32:54 +0100

http://www.bayes.co.uk/xml/index.xml?/xml/tutorial/paging/paging.xml
http://www.bayes.co.uk/xml/index.xml?/xml/tutorial/filtering/filter.xml

Ciao Chris

XML/XSL Portal
http://www.bayes.co.uk/xml

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
> Katie McNally
> Sent: 08 October 2001 16:05
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  Paging and Sorting
>
>
> I would like to incorporate the following two capabilities
> into a page using
> XSL: Paging and Sorting.
>
> Since over 100 loans will be returned in the XML, I would
> like to display
> ten at a time, and allow the user the ability (through links)
> to go to the
> "Next Page" and "Previous Page" of 10 loans, as well as skip
> ahead to the
> "Last Page" or back to the "First Page" of loans.  In
> addition to this
> paging functionality, sorting capabilities must also be
> available.  Each
> column title in the table must be a link, that when clicked,
> sorts the table
> by that column.  The paging functionality must still be
> available.  When the
> page first opens it should display the first ten loans,
> sorted by Loan
> Number.  If the user then selects the "Status Date" column
> title link, the
> table will sort by Status date, displaying the first ten
> loans with the most
> recent date.  The user can then page to other loans in the
> returned list of
> loans.
>
> Any suggestions for how to do this?
>
> The Column titles are Loan ID, Borrower Name, Loan Amount,
> Rate, Status,
> Status Date.  Borrower Last Name value displayed is for
> borrower with Rank =
> 1.  Rate and Loan Amount are displayed when Selected = True.
>
> An abbreviated example of the XML:
>
> <LoanSet>
> <Loan>
> 	<LoanId>9921234</LoanId>
> 	<Status>New</Status>
> 	<StatusDate>16-Dec-1999 09:26:14</StatusDate>
> 	<LoanBorrowerSet>
> 		<Borrower>
> 			<Rank>1</Rank>
> 			<LastName>Smith</LastName>
> 		</Borrower>
> 		<Borrower>
> 			<Rank>2</Rank>
> 			<LastName>Jones</LastName>
> 		</Borrower>
> 	</LoanBorrowerSet>
> 	<LoanScenarioSet>
> 		<Scenario>
> 			<Selected>True</Selected>
> 			<LoanAmount>100000</LoanAmount>
> 			<ScenarioDetailSet>
> 				<ScenarioDetail>
> 					<Rate>7</Rate>
> 				</ScenarioDetail>
> 			</ScenarioDetailSet>
> 		</Scenario>
> 		<Scenario>
> 			<Selected>False</Selected>
> 			<LoanAmount>200000</LoanAmount>
> 			<ScenarioDetailSet>
> 				<ScenarioDetail>
> 					<Rate>6.5</Rate>
> 				</ScenarioDetail>
> 			</ScenarioDetailSet>
> 		</Scenario>
> 	</LoanScenarioSet>
> </Loan>
> <Loan>
> 	<LoanId>5256723</LoanId>
> 	<Status>New</Status>
> 	<StatusDate>18-Mar-1998 02:21:11</StatusDate>
> 	<LoanBorrowerSet>
> 		<Borrower>
> 			<Rank>1</Rank>
> 			<LastName>Johnson</LastName>
> 		</Borrower>
> 		<Borrower>
> 			<Rank>2</Rank>
> 			<LastName>Douglas</LastName>
> 		</Borrower>
> 	</LoanBorrowerSet>
> 	<LoanScenarioSet>
> 		<Scenario>
> 			<Selected>True</Selected>
> 			<LoanAmount>150000</LoanAmount>
> 			<ScenarioDetailSet>
> 				<ScenarioDetail>
> 					<Rate>6.7</Rate>
> 				</ScenarioDetail>
> 			</ScenarioDetailSet>
> 		</Scenario>
> 		<Scenario>
> 			<Selected>False</Selected>
> 			<LoanAmount>220000</LoanAmount>
> 			<ScenarioDetailSet>
> 				<ScenarioDetail>
> 					<Rate>7</Rate>
> 				</ScenarioDetail>
> 			</ScenarioDetailSet>
> 		</Scenario>
> 	</LoanScenarioSet>
> </Loan>
> </LoanSet>
>
> Thanks,
> Katie
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
>  XSL-List info and
> archive:  http://www.mulberrytech.com/xsl/xsl-list
>
>

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp