Attributr in XPath

Hi,

First there is a XML:

<?xml version="1.0"?>
<FAMILYTREE>
   <PERSON  ID="p1">
       <NAME>Jean Dupont</NAME>
       <BORN>12. März 1801</BORN>
       <DIED>12. März 1901</DIED>
       <SPOUSE IDREF="p2"/>
   </PERSON>
   <PERSON ID="p2">
       <NAME>Marianne Durand</NAME>
       <BORN>1. April 1805</BORN>
       <DIED>31. Dezember</DIED>
       <SPOUSE IDREF="p1"/>
   </PERSON>
   <PERSON ID="p3" FATHER="p1" MOTHER="p2">
      <NAME>Anne Dupont</NAME>
      <BORN>11. Februar 1838</BORN>
      <DIED>12. April 1912</DIED>
      <SPOUSE IDREF="p4"/>
   </PERSON>
   <PERSON ID="p4">
      <NAME>Hans Müller</NAME>
      <SPOUSE IDREF="p3"/>
   </PERSON>
   <PERSON ID="p5" FATHER="p1" MOTHER="p2">
      <NAME>Eugène Dupont</NAME>
      <BORN>3. Januar 1839</BORN>
      <DIED>12. April 1839</DIED>
   </PERSON>
   <PERSON ID="p6" FATHER="p1" MOTHER="p2">
      <NAME>Marie Dupont</NAME>
      <BORN>3. Dezember 1840</BORN>
      <DIED>12. Juli 1920</DIED>
      <SPOUSE IDREF="p7"/>
   </PERSON>
   <PERSON ID="p7">
      <NAME>Philippe Dubois</NAME>
      <BORN>3. Januar 1846</BORN>
      <SPOUSE IDREF="p6"/>
   </PERSON>
   <PERSON ID="p8" FATHER="p7" MOTHER="p6">
      <NAME>Achille Hector Archibald Dubois</NAME>
      <BORN>29. Oktober 1870</BORN>
      <DIED>3. Mai 1938</DIED>
   </PERSON>
</FAMILYTREE>

Second there is my XSLT-stylesheet:

Third there is the output:

<html> 
   <body> 
      <table border="1"> 
         <tr> 
            <th>Name</th> 
            <th>Mutter</th> 
            <th>Vater</th> 
         </tr> 
         <tr> 
            <td>Jean Dupont</td> 
            <td></td> 
            <td></td> 
         </tr> 
         <tr> 
            <td>Marianne Durand</td> 
            <td></td> 
            <td></td> 
         </tr> 
         <tr> 
            <td>Anne Dupont</td> 
            <td>p2</td> 
            <td>p1</td> 
         </tr> 
         <tr> 
            <td>Hans Müller</td> 
            <td></td> 
            <td></td> 
         </tr> 
         <tr> 
            <td>Eugène Dupont</td> 
            <td>p2</td> 
            <td>p1</td> 
         </tr> 
         <tr> 
            <td>Marie Dupont</td> 
            <td>p2</td> 
            <td>p1</td> 
         </tr> 
         <tr> 
            <td>Philippe Dubois</td> 
            <td></td> 
            <td></td> 
         </tr> 
         <tr> 
            <td>Achille Hector Archibald Dubois</td> 
            <td>p6</td> 
            <td>p7</td> 
         </tr> 
      </table> 
   </body> 
</html>

Everything works fine, there is one mistake only. In the output should not be for instance p6 or p7. There should appear the real names like Marie Dupont or Philippe Dubois. How can I achieve this?

Regards, Urs

So you need to take the value of the attribute, and use that in an XPath expression to find the name of the person it matches? Try using this expression:

<xsl:value-of select="/FAMILYTREE/PERSON[@ID = current()/@MOTHER]/NAME" />

Translates as "find the PERSON with an ID attribute matching the MOTHER attribute of my current node, and take their name".

Or if you expect to do this on larger documents, you might want to consider an <xsl:key> element. The w3schools tutorial about that element has an example which could almost be dropped unchanged into your code.