This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Paging and Sorting
- To: xsl-list at lists dot mulberrytech dot com
- Subject: [xsl] Paging and Sorting
- From: "Katie McNally" <kmcnally9 at hotmail dot com>
- Date: Mon, 08 Oct 2001 10:04:53 -0500
- Reply-To: xsl-list at lists dot mulberrytech 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