[xsl] Paging and Sorting

["Katie McNally" <kmcnally9 at hotmail dot com>]

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