Multiple Instances of a node

[ashridharan]

Hi
I have an XML document which looks like
<ROOT>
<PARENT Id=&quot;1&quot;>
<SOMENODE>ABC</SOMENODE>
<SOMENODE>123</SOMENODE>
<SOMENODE>XYZ</SOMENODE>
</PARENT>
<PARENT Id=&quot;2&quot;>
<SOMENODE>123</SOMENODE>
</PARENT>
</ROOT>
As can be seen, there are multiple instances of &quot;SOMENODE&quot;. the condition i want to execute is to return all &quot;PARENT&quot; ids which has no instance of &quot;SOMENODE = 123&quot;

However, the XML parser (MSXML as well as .NET) takes each node as an individual node and does not group them. This returns node 1 in the result set. This is however the wrong result as neither of the PARENT nodes satisfy this clause.

Does anyone have any clues about how to solve this ?

thanks in advance

 

[JJR]

Hi ashridharan,

Try using:

<xsl:for-each select=&quot;ROOT\PARENT[not(SOMENODE = &quot;123&quot;)]&quot;>
   <xsl:value-of select=&quot;@Id&quot;/>
</xsl:for-each>

Good luck!

Jordi Reineman