|
Subject: [xsl] xsl grouping problem From: rj_peterson@xxxxxxxxxxxxx Date: Tue, 23 Mar 2004 14:03:24 -0600 |
I have the following xml file that I want to use to create a table with the
values in the format below. I have some xsl I have been trying but I cant
get the following-sibling to quite work right. Any suggestions?? Thanks!!
XML
<?xml version="1.0"?>
<DATABASE>
<ID>306030300570011572</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>OMCL</SYMBOL>
<ID>306030300570011573</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>ORCL</SYMBOL>
<ID>306030300570011571</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>TLCV</SYMBOL>
<ID>306030300570011572</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>OMCL</SYMBOL>
<ID>306030300570011573</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>ORCL</SYMBOL>
.........
<ID>306030300570011571</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>TLCV</SYMBOL>
<ID>306030300570011572</ID>
<TYPE>18</TYPE>
<REP>CKCK</REP>
<SYMBOL>OMCL</SYMBOL>
<ID>306030300570011573</ID>
<TYPE>18</TYPE>
<REP>CKCK</REP>
<SYMBOL>ORCL</SYMBOL>
<ID>306030300570011571</ID>
<TYPE>20</TYPE>
<REP>CKCK</REP>
<SYMBOL>TLCV</SYMBOL>
</DATABASE>
XSL
<xsl:variable name="symbol" select="DATABASE/SYMBOL"/>
<xsl:variable name="type" select="DATABASE/TYPE"/>
<xsl:for-each select="DATABASE/ID[position() mod 3 = 1]">
<xsl:variable name="position" select="position()"/>
<tr>
<td>
<xsl:value-of select="."/>-<xsl:value-of select="$type"/>-
<xsl:value-of select="$symbol[$position]"/>
</td>
<xsl:for-each select="following-sibling::node()[position() < 3]">
<td>
<xsl:value-of select="."/>-<xsl:value-of select="$type"/>-
<xsl:value-of select="$symbol[$position]"/>
</td>
</xsl:for-each>
</tr>
</xsl:for-each>
Desired html
<table>
<tr>
<td>IDVALUE - TYPEVALUE - SYMBOVALUEL</td>
<td>IDVALUE - TYPEVALUE - SYMBOVALUEL</td>
<td>IDVALUE - TYPVALUEE - SYMBOVALUEL</td>
</tr>
<tr>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
</tr>
...................
<tr>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
<td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td>
</tr>
</table>
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| RE: [xsl] xpath: use translate() co, Josh Canfield | Thread | RE: [xsl] xsl grouping problem, Josh Canfield |
| [xsl] xpath: use translate() conver, R. Erick Emde | Date | RE: [xsl] Problem with jsp expressi, Ivan Pedruzzi |
| Month |