using for each and going back in the xml tree

smiter · January 10th, 2007, 04:31 AM

Hello,

I am trying to go back in an xml tree within a for each loop and this is not giving the right output. Maybe someone can give me a clou of what i am doing wrong and how i can get the right output.

XML:

Code:

- <root>
  <pagetype /> 
  <name>AdvertisementManagementGrid</name> 
  <id>-1</id> 
  <pageid>178</pageid> 
  <detailpageid>179</detailpageid> 
- <data>
- <data>
  <row intID="17" LastChange="2007-01-10T08:54:39.560" intEmployerID="114" strTitle="Marketing Manager" intResultID="1" /> 
  <row intID="16" LastChange="2007-01-10T08:54:32.107" intEmployerID="114" strTitle="Webdesigner" intResultID="2" /> 
  <row intID="15" LastChange="2007-01-10T08:54:22.593" intEmployerID="114" strTitle="Cameraman" intResultID="3" /> 
  </data>
- <searchfields>
  <row intPrimaryKeyID="17" strSearchNode="/Root/Information/Category" strSearchValue="20" intLanguageID="0" /> 
  <row intPrimaryKeyID="16" strSearchNode="/Root/Information/Category" strSearchValue="10" intLanguageID="0" /> 
  <row intPrimaryKeyID="15" strSearchNode="/Root/Information/Category" strSearchValue="10" intLanguageID="0" /> 
  </searchfields>
  <pageindex>1</pageindex> 
  <recordcount>3</recordcount> 
  </data>
</root>

XSL code:

Code:

<xsl:for-each select="root/data/data/row/row">
        <xsl:variable name="Category" select="../../searchfields/row/@strSearchValue" />
        <xsl:variable name="rowPID" select="../../searchfields/row/@intPrimaryKeyID" />
        <xsl:variable name="rowID" select="@intID" />
        <tr>
          <td>
            <a>
              <xsl:attribute name="href">
                default.aspx?pageid=176&amp;id=<xsl:value-of select="@intID"/>
              </xsl:attribute>
              <xsl:value-of select="@strTitle"/>
            </a>
          </td>
          <td>
            <xsl:value-of select="$Category[$rowPID = $rowID]"/>
          </td>
          <td></td>
        </tr>
      </xsl:for-each>

This is the output from the above xslt:
Marketing Manager 20
Webdesigner 20
Cameraman 20

But the output has to be:

Marketing Manager 20
Webdesigner 10
Cameraman 10

Hope someone can help me!

Thanks

Smiter

mhkay · January 10th, 2007, 05:12 AM

There's clearly something wrong with this expression

<xsl:value-of select="$Category[$rowPID = $rowID]"/>

because the value of the predicate doesn't depend on the context node.

But I can't see how you get your current output. There are six <row> elements in the input, so I would expect six <tr> elements in the output.

I would do something like this:

<xsl:key name="k" match="searchfields/row" use="intPrimaryKeyID"/>

then

<xsl:for-each select="/root/data/row">
  <tr>
    <td>
      <a href="default.aspx?pageid=176&id={@intID}"/>
        <xsl:value-of select="@strTitle"/>
      </a>
    </td>
    <td>
      <xsl:value-of select="key('k', @intId)/@strSearchValue"/>
    </td>
  </tr>
</xsl:for-each>

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

smiter · January 10th, 2007, 05:57 AM

Thanks for your quick reply! It all works fine now thanks to your solution.

Smiter