Use the following transformation:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:template match="rowset">
<site>
<xsl:apply-templates select="row[site_parent = 0]"/>
</site>
</xsl:template>
<xsl:template match="row">
<xsl:copy-of select="site_id | site_name"/>
<xsl:variable name="vChildren"
select="../row[site_parent = current()/site_id]"/>
<xsl:if test="$vChildren">
<site>
<xsl:apply-templates select="$vChildren"/>
</site>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
When applied against your source.xml:
<page>
<rowset>
<row>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
<row>
<site_id>2</site_id>
<site_name>Test Child1 of Test Parent1</site_name>
<site_parent>1</site_parent>
<level>2</level>
<path>/0/1</path>
</row>
<row>
<site_id>4</site_id>
<site_name>Test Child1 of Test Child1</site_name>
<site_parent>2</site_parent>
<level>3</level>
<path>/0/1/2</path>
</row>
<row>
<site_id>3</site_id>
<site_name>Test Parent2</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
</rowset>
</page>
the wanted result is produced:
<site>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site>
<site_id>2</site_id>
<site_name>Test Child1 of Test Parent1</site_name>
<site>
<site_id>4</site_id>
<site_name>Test Child1 of Test Child1</site_name>
</site>
</site>
<site_id>3</site_id>
<site_name>Test Parent2</site_name>
</site>
=====
Cheers,
Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL
"Todd Kleine" <tkleine(_at_)earthlink(_dot_)net> wrote in message
news:000601c368be$ebce32e0$6401a8c0(_at_)pinehurst(_dot_)(_dot_)(_dot_)
Hello,
I am new to xsl and am having a tough time with a template to transform
the
results of an oracle "connect by" query into a hierarchical xml document.
The xml results of a sample query is below:
<page>
<rowset>
<row>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
<row>
<site_id>2</site_id>
<site_name>Test Child1 of Test Parent1</site_name>
<site_parent>1</site_parent>
<level>2</level>
<path>/0/1</path>
</row>
<row>
<site_id>4</site_id>
<site_name>Test Child1 of Test Child1</site_name>
<site_parent>2</site_parent>
<level>3</level>
<path>/0/1/2</path>
</row>
<row>
<site_id>3</site_id>
<site_name>Test Parent2</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
</rowset>
</page>
where the site_parent value is the site_id of it's parent and a
site_parent
of 0 is a top-level node.
I would like to produce a hierarchical xml doc based upon these results of
the form
<site>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site>
<site_id>2</site_id>
<site_name> Test Child1 of Test Parent1</site_name>
<site>
<site_id>4</site_id>
<site_name>Test Child2 of Test Child1</site_name>
</site>
</site>
</site>
<site>
<site_id>3</site>
<site_name>Test Parent2</site_name>
</site>
Has anyone had experience with this type of transform? Any help would be
appreciated.
Thanks in advance
todd
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list