Hi I am trying to do the following with a xslt page for xml output. I am not doing html rendering and I need all the elements to output

1) Have a flat DB Table that I read into XML. It comes out as
<NODES>
  <NODE>
     <name>A</name>
     <id>1</id>
     <parent>Root</parent>
  </NODE>
  <NODE>
     <name>B</name>
     <id>2</id>
     <parent>1</parent>
  </NODE>
  <NODE>
     <name>C</name>
     <id>3</id>
     <parent>2</parent>
  </NODE>
  <NODE>
     <name>D</name>
     <id>4</id>
     <parent>Root</parent>
  </NODE>
  <NODE>
     <name>E</name>
     <id>5</id>
     <parent>4</parent>
  </NODE>
  <NODE>
     <name>F</name>
     <id>6</id>
     <parent>4</parent>
  </NODE>
</NODES>

2) need to change the format to this so I can use it in a web control
This is a nested xml file that shows the relationship
<NODES>
  <NODE>
     <name>A</name>
     <id>1</id>
     <parent>Root</parent>
     <NODE>
        <name>B</name>
        <id>2</id>
        <parent>1</parent>
        <NODE>
           <name>C</name>
           <id>2</id>
           <parent>Root</parent>
        </NODE>
     </NODE>
  </NODE>
  <NODE>
     <name>D</name>
     <id>4</id>
     <parent>Root</parent>
     <NODE>
        <name>E</name>
        <id>5</id>
        <parent>4</parent>
     </NODE>
     <NODE>
        <name>F</name>
        <id>6</id>
        <parent>4</parent>
     </NODE>
  </NODE>
</NODES>

Thanks,
Ben

You want something like this:

<xsl:template match="/">
  <xsl:apply-templates select="/NODES/NODE[parent='Root']"/>
</xsl:template>

<xsl:template match="NODE">
  <NODE>
    <xsl:copy-of select="*"/>
    <xsl:apply-templates select="/NODES/NODE[parent=current()/id]"/>
  </NODE>
</xsl:template>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Michael,

I modified (to what I need) and tested out your transform in altovaXML and CookTop xslt parsers. This is exactly the solution I needed. I will check out your book!! Hopefully you have a recursive chapter.


Cheers,
Ben