How do I produce one output for a list of dates that meet one month

BrandonPar · May 20, 2002

Hi,

I'm trying to look at a list of dates and if one of those dates is in january then produce an output. The problem i have is that i don't want to produce the output twice even if there are dates in January listed more than once.

The following XML produces Y twice in the January column

<?xml version="1.0" ?>
<?xml-stylesheet type="text/xsl" href="island.xsl"?>
<xmldata>
<workactivity>
<text>Absence</text>
<question>
<text>A Review Appointment must be made for Jarvis Cocker on 03/10/2001</text>
<date>
<day>01</day>
<month>01</month>
<year>1999</year>
</date>
<date>
<day>11</day>
<month>01</month>
<year>1999</year>
</date>
<date>
<day>11</day>
<month>02</month>
<year>1999</year>
</date>
</question>
<question>
<text>My second question</text>
<date>
<day>21</day>
<month>11</month>
<year>1999</year>
</date>
<date>
<day>07</day>
<month>07</month>
<year>2000</year>
</date>
</question>
</workactivity>
</xmldata>

Here is the stylesheet

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- <xsl:stylesheet xmlns:xsl="

http://www.w3.org/TR/WD-xsl">

-->
<xsl:stylesheet version="1.0" xmlns:xsl="

http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<body>
<table border="2" bgcolor="yellow">
<tr>
<th>Question</th>
<th>J</th>
</tr>
<xsl:for-each select="xmldata/workactivity/question">
<tr>
<td><xsl:value-of select="text"/></td>
<td>
<xsl:for-each select="date">
<xsl:if test="month='01'">
Y
</xsl:if>
</xsl:for-each>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

If anybody can give me some pointers i would be very grateful.

Kind Regards,

Brandon Par

flumpy · May 20, 2002

interesting...

try changing the for loop and use the distinct-values function like this:
...

<xsl:for-each select="xmldata/workactivity/question">
<tr>
<td><xsl:value-of select="text"/></td>
<td>
<xsl:for-each select="distinct-values(date)">
<xsl:if test="month='01'">
Y
</xsl:if>
</xsl:for-each>
</td>
</tr>
</xsl:for-each>

...

I dont have my debugger, but that should work

Matt

flumpy · May 21, 2002

ack it doesnt.

apparently its an XQuery function... sorry.

still, you could write a function yourself to do the same thing...!

BrandonPar · May 21, 2002

Hi Matt,

Thanks for your comments, i've found another way of doing it as follows.

<xsl:for-each select="date[month='01']">
<xsl:if test="position()=1">
<xsl:if test="status='completed'">
<img src="completed" border="0" alt="completed"/>
</xsl:if>
</xsl:if>
</xsl:for-each>

The code uses a for loop on only months that match 01 and then if the position is equal to 1 i produce the output

regards,

Brandon Par

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How do I produce one output for a list of dates that meet one month

BrandonPar

Programmer

flumpy

Programmer

flumpy

Programmer

BrandonPar

Programmer

Similar threads

Part and Inventory Search

Sponsor