Subject: [xsl] Calling exslt date function From: "Tom Froehlich" <Tom@xxxxxxxxx> Date: Tue, 12 Aug 2003 16:33:33 -0700 |
Well, I got a plain xml file of events that needs to be transformed to html via an xsl stylesheet. The transformation should only include events with a begin date equal to or greater than the current date (system date), all past events in the xml file are ignored. We upload a fresh xml file once per month or so. Our server runs msxml4 and I got the exslt date functions installed. Somehow, I cannot figure how to get the dynamic, current date to work in my stylesheet. I get no error message, just no events and no current date value.... It works fine when I use the enterdate variable instead. The xml: <?xml version="1.0" encoding="UTF-8"?> <dataroot xmlns:od="urn:schemas-microsoft-com:officedata"> <tblCurrentEvents> <EventID>1</EventID> <EventName>The Financial Cruncher Demo</EventName> <EventDescription>Two hour demo of the new features in FC 4.2.</EventDescription> <EventType>Demo</EventType> <EventAudience>For current users of FC only.</EventAudience> <EventBeginDate>2003-06-04T00:00:00</EventBeginDate> <EventEndDate>2003-06-04T00:00:00</EventEndDate> <EventBeginTime>09:30 AM</EventBeginTime> <EventEndTime>11:30 AM</EventEndTime> <FeeStatus>FREE</FeeStatus> <Fee>0</Fee> <Discount>10% for each additional attendee per organization.</Discount> <EventLocation>San Francisco Training Center</EventLocation> <EventStatus>open</EventStatus> <EventSchedule>recurring-monthly</EventSchedule> <EventRegistration>Event registration required.</EventRegistration> </tblCurrentEvents> <tblCurrentEvents> . . . The xsl: <?xml version="1.0" encoding="utf-8" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:date="http://exslt.org/dates-and-times" extension-element-prefixes="date"> <xsl:import href="functions\date\date.date.template.xsl" /> <xsl:variable name="enterdate" select="'2003-08-01T00:00:00Z'"/> <!-- just in case --> <xsl:variable name="currentdate"> <xsl:call-template name="date:date"> <xsl:with-param name="date-time" select="." /> </xsl:call-template> </xsl:variable> <xsl:template match="/"> <xsl:for-each select="//tblCurrentEvents"> <xsl:variable name="begindate" select="EventBeginDate" /> <xsl:variable name="showdateBegin" select="EventBeginDate"/> <xsl:variable name="showdateEnd" select="EventEndDate"/> <xsl:variable name="YearBegin" select="substring-before($showdateBegin, '-')" /> <xsl:variable name="MonthBegin" select="substring($showdateBegin, 6, 2)" /> <xsl:variable name="DayBegin" select="substring($showdateBegin, 9, 2)" /> <xsl:variable name="YearEnd" select="substring-before($showdateEnd, '-')" /> <xsl:variable name="MonthEnd" select="substring($showdateEnd, 6, 2)" /> <xsl:variable name="DayEnd" select="substring($showdateEnd, 9, 2)" /> <xsl:choose> <xsl:when test="translate(substring-before($begindate, 'T'), '-', '') >= translate(substring-before($currentdate, 'T'), '-', '')"> <p align="left" class="body"> <div align="left"> <table border="0" cellpadding="0" style="border-collapse: collapse" width="440" cellspacing="2"> <tr> <td width="10%" valign="top">Title:</td> <td width="60%" valign="top"><b><xsl:value-of select="EventName"/></b></td> <td width="15%" valign="top"><xsl:text>Event ID: </xsl:text></td> <td width="15%" valign="top"><xsl:value-of select="EventID"/></td> </tr> <tr> <td valign="top">Date(s):</td> <td colspan="3" valign="top"><xsl:value-of select="$MonthBegin"/><xsl:text>/</xsl:text><xsl:value-of select="$DayBegin"/><xsl:text>/</xsl:text><xsl:value-of select="$YearBegin"/><xsl:text> to </xsl:text><xsl:value-of select="$MonthEnd"/><xsl:text>/</xsl:text><xsl:value-of select="$DayEnd"/><xsl:text>/</xsl:text><xsl:value-of select="$YearEnd"/></td> </tr> . . . I'll be happy to make a small donation to your favorite charity... Regards, Tom ************************************************************** Tom Froehlich, CFRE Fundraising Consultant Armanino McKenna LLP (925) 790-2600 tom@xxxxxxxxx XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Re: Value of NDATA entities i, James Cummings | Thread | Re: [xsl] Calling exslt date functi, Maik Stührenberg |
Re: AW: AW: [xsl] Using key() from , Peter Flynn | Date | [xsl] XSL(check attribute exists in, gaya3 kar |
Month |