[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] 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

---