Select correct child node

richieWolf · September 24th, 2008, 07:10 AM

I have the follow XML, it can change but this is how I thought it will be structured.

For example, I have a value stored in a variable $VALUE that contains 200. I want check which <LOWER> and <UPPER> tags it falls in.
Once I find the matching one I want to retrieve <NAME>. So here I want to return Stage3. Can this be done in XSL?
I'm not sure how to do it.

      <Stage>
          <NAME>Stage1</NAME>
          <LOWER>0</LOWER>
          <UPPER>114</UPPER>
      </Stage>
      <Stage>
          <NAME>Stage2</NAME>
          <LOWER>115</LOWER>
          <UPPER>150</UPPER>
      </Stage>
       <Stage>
          <NAME>Stage3</NAME>
          <LOWER>151</LOWER>
          <UPPER>999</UPPER>
      </Stage>

Martin Honnen · September 24th, 2008, 07:19 AM

One XPath expression suffices:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="2.0">

  <xsl:param name="VALUE" select="200"/>

  <xsl:template match="/">
    <xsl:value-of select="descendant::Stage[number(LOWER) &lt; $VALUE and number(UPPER) &gt; $VALUE]/NAME"/>
  </xsl:template>

</xsl:stylesheet>

--
Martin Honnen
Microsoft MVP - XML

richieWolf · September 24th, 2008, 07:58 AM

That's really cool, thanks a lot.

Btw, how can I display <= and >= instead of < (<) and > (>)?

Martin Honnen · September 24th, 2008, 08:08 AM

Code:

<xsl:value-of select="descendant::Stage[number(LOWER) &lt;= $VALUE and number(UPPER) &gt;= $VALUE]/NAME"/>

--
Martin Honnen
Microsoft MVP - XML

richieWolf · September 24th, 2008, 08:53 AM

Of course! Stupid me! Thanks