[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Paging and Sorting

Subject: Paging and Sorting
From: "Katie McNally" <kmcnally9@xxxxxxxxxxx>
Date: Mon, 08 Oct 2001 10:04:53 -0500
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



Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.