newbie question: combining two trees

Subject: newbie question: combining two trees
From: Marko Draisma <mdraisma@xxxxxxxxxxx>
Date: Mon, 24 Jan 2000 21:5:0 +0100
In one xml file I have two trees: one describes the departments, the other employees. I want to generate a html-file in which both trees are combined.
I guess I have to use variables or parameters, but nothing seems to work. Help is deeply appreciated.

This is my xml-file:

<?xml version="1.0"?>
<TABLES>
<DEPTS>
<ROW_DEPT>
      <DEPTNR>10</DEPTNR>
      <NAME>BOEKHOUDING</NAME>
    </ROW_DEPT>
<ROW_DEPT>
      <DEPTNR>20</DEPTNR>
      <NAME>ONDERZOEK</NAME>
    </ROW_DEPT>
</DEPTS>
<EMPS>
<ROW_EMP>
      <NAME>SMITS</NAME>
      <DEPTNR>20</DEPTNR>
    </ROW_EMP>
<ROW_EMP>
      <NAME>HEUVEL</NAME>
      <DEPTNR>10</DEPTNR>
    </ROW_EMP>
</EMPS>
</TABLES>

And this is my attempt to combine both tables:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
  <xsl:template match="/">
    <html>
      <head>
        <title>Employees</title>
      </head>
      <body>
        <xsl:apply-templates/>
      </body>
    </html>
  </xsl:template>
  <xsl:template match="DEPTS">
      <xsl:for-each select="ROW_DEPT">
              <xsl:value-of select="NAME"/><br/>
        <xsl:variable name="test" select="DEPTNR"/>
        <xsl:for-each select=".../EMPS/ROW_EMP[DEPTNR=$test]">
                <xsl:value-of select="NAME"/>
        </xsl:for-each>
         <br/>
      </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

Marko Draisma.
Marko Draisma
mdraisma@xxxxxxxxxxx
http://huizen.nhkanaal.nl/~huissie


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread