This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Grouping by a piece of a date
- To: xsl-list at mulberrytech dot com
- Subject: RE: Grouping by a piece of a date
- From: Michal_Mart at cch-lis dot com
- Date: Thu, 7 Sep 2000 14:58:38 -0400
- cc: jsaylor at diamondtechnology dot com
- Reply-To: xsl-list at mulberrytech dot com
Hi Jeff,
I think you will have better luck if you change your select to this
<xsl:for-each
select="/xml/rs:data/z:row[generate-id(.)=generate-id(key('foo',substring-before(@dCreated,'T')))]"
>
Hope this helps,
Michal
Jeff Saylor <JSaylor@diamondtechnology.com> on 09/07/2000 10:13:51 AM
Please respond to xsl-list@mulberrytech.com
To: xsl-list@mulberrytech.com
cc: (bcc: Michal Mart)
Subject: RE: Grouping by a piece of a date
I had pitched this yesterday in response to Steve's answer, but hadn't
gotten any further input so I thought I might stoke the fire a bit - to
summarize...
From this XML:
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<rs:data>
<z:row iID="1" dCreated="1900-01-01T01:00:00"/>
<z:row iID="2" dCreated="1900-01-02T01:00:00"/>
<z:row iID="3" dCreated="1900-01-02T02:00:00"/>
<z:row iID="4" dCreated="1900-01-04T01:00:00"/>
</rs:data>
</xml>
I am trying to group the elements based on only the date part of the
dCreated value - resulting in:
1900-01-01T01:00:00 - iID1
1900-01-02T01:00:00 - iID2, iID3
1900-01-04T01:00:00 - iID4
Steve Muench suggested that the following should net me the unique keys that
I could use the Meuncharian method to process through:
<xsl:key name="foo"
match="/xml/rs:data/z:row"
using="substring-before(@dCreated,'T')"/>
Unfortunately, the following outputs no results (using the MSXML3 July
preview rel).:
<xsl:for-each
select="/xml/rs:data/z:row[generate-id(.)=generate-id(key('foo',.))]"
>
<xsl:value-of select="." />
</xsl:for-each>
Am I missing something/doing something incorrectly, or could someone
confirm/deny that MSXML3 doesn't currently support this?
Much appreciation in advance - Cheers,
Jeffrey J. Saylor
Senior Internet Developer
Diamond Technology, Inc.
707 Mendham Blvd., Suite 104
Orlando, FL 32825
Phone: (407) 262-9000 Ext 266
Fax: (407) 262-9010
Email: jsaylor@DiamondTechnology.com
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list