SSDN - how to compare a current value to a value in the next node

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Dexter McCloud

Subject: how to compare a current value to a value in the next node
Author: Dexter McCloud
Date: 23 Sep 2004 11:11 AM

I am a fledgling developer in the XSLT world. So, I apologize if this
is an obvious question. I have XML, returned from my database, that will look like this:

<row row_type="order_info" order_id="63893" item_id="1146211"/>
<row row_type="order_info" order_id="63903" item_id="1146216"/>
<row row_type="order_info" order_id="63904" item_id="1146216"/>

I am generating HTML based on the values in the XML. I want to emit a
<TR> tag for every row of data; that's the easy part. However, if the
item_id is the same, I want to make the data part of the SAME <TR>.

Example using the data above:

<table>
<tr>
<td>order id</td>
<td>Item id</td>
</TR>
<tr>
<td>63893</td>
<td>1146211</td>
</TR>
<tr>
<td>63903<br>63904
</td>
<td>1146216</td>
</TR>
</table>

As you can see, because the "item_id (2nd column) is the same, I simply
combined the data inside the <TD> tags. Otherwise, each line will
occupy it's own <TR>.

But, how do I do this with XSLT?

Thanks,

Dexter (new user)

item_info.xml
example of typical data (4 rows)

Minollo I.

Subject: how to compare a current value to a value in the next node
Author: Minollo I.
Date: 23 Sep 2004 05:58 PM

[Song's reply wasn't rendered properly; here is a second attempt]
------------

Hi, Dexter

the task you described is very common and xslt 1.0 is not good in doing
that. The best way is to use key and generate-id to do grouping which I
guess is not very easy to understand if you are new to xslt. Here I will
show you an easier solution( but not the fastest) and hope it helps.

For each row element, we will check if it is already processed by
checking if it is the first element with the same @item_id. If it is, we
will work on this @item_id and find out all the row element with the
same @item_id and output all of them with <td> element. If it is not the
first, we know elements with this @item_id is already processed and we
don't do anything.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>

<xsl:template match="/">
<table>
<xsl:for-each select="order/row">
<xsl:variable name="id" select="@item_id"/>
<xsl:if test="count(preceding-sibling::*[@item_id = $id])=0">
<tr>
<td>
<xsl:for-each select="../row[@item_id = $id]">
<xsl:value-of select="@order_id"/>
<xsl:if test="position() != last()">
<br/>
</xsl:if>
</xsl:for-each>
</td>
<td>
<xsl:value-of select="@item_id"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

Please note in xslt 2.0, this is very easy by using xsl:for-each-group.
We are going to ship next major release very soon and it will support
xslt2.0.

Song.

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.