|
|
 next
|
  Subject: XSLT: Ordered List (based on result, not node position)?
Author: James Delaney
Date: 30 Jun 2009 02:23 PM
|
All,
I am a new comer to the XML/XSLT scene. I am attempting to receive a total count, or list of total matches that fulfill my if statements. I have attempted to use everything from xsl:number, xsl:count, xsl:value count/sum, the whole works. Right now, I am using a list <ol></li> but its giving me a bullet point and not a sequential number. Any help would be great!
My output looks like this:
CountTest
# Student ID ProgamType Gender Credits
343434 Transfer Male 16
323232 Transfer Male 11
32322 Transfer Male 18
6464 Transfer Male 13
My desired output SHOULD look like this, but the first column (1,2,3,4) are appearing as bullets such as the output above:
CountTest
# Student ID ProgamType Gender Credits
1 646111 Transfer Male 16
2 6463343 Transfer Male 11
3 323234 Transfer Male 18
4 1045353 Transfer Male 13
This is the XSLT I am applying:
<?xml version='1.0'?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<h2>CountTest</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th>#</th>
<th>Student ID</th>
<th>ProgamType</th>
<th>Gender</th>
<th>Credits</th>
</tr>
<xsl:for-each select="Census/Student">
<xsl:if test="
(Gender='Male') and
(@AdmitTerm!='Fall Semester 2008') and
(@ProgramType='Transfer') and
(TotCredits/@Load>11) and
(TotCredits/@UG<30)
">
<tr>
<ol start="1">
<td><li></li></td>
<td><xsl:value-of select="@Id"/></td>
<td><xsl:value-of select="@ProgramType"/></td>
<td><xsl:value-of select="Gender"/></td>
<td><xsl:value-of select="TotCredits/@UG"/></td>
</ol>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
This is one student entry of my student census XML file:
<Student Id="6463343" ProgramType="Transfer" AdmitTerm="N/A">
<Gender>Male</Gender>
<Ethnicity>Black (Non-Hispanic Origin)</Ethnicity>
<BirthDate>31572</BirthDate>
<Citizenship>N/A</Citizenship>
<Degree>Bachelor of Science</Degree>
<Major>Nursing 2 + 2 Program</Major>
<DegreeTWO>N/A</DegreeTWO>
<MajorTWO>N/A</MajorTWO>
<Advisor>Canton</Advisor>
<FinHSGPA>N/A</FinHSGPA>
<TotCredits UG="11" Grad="0" Load="13" TransferCredits="N/A"/>
<PermAddress State="CA">
<City>Oakland</City>
</PermAddress>
<SAT1 type="N/A">
<Score>N/A</Score>
</SAT1>
<SAT2 type="N/A">
<Score>N/A</Score>
</SAT2>
<Classification>trad undergrad</Classification>
|
|
|
|
top