Thread: XSL:if testing for a value in one query/template with values from another.

Hello,
I have two queries on one custom xml package.
One get's the products using the stock aspdnsf_GetProducts SP. the second I want to use to filter out products from the first.
First query uses a template to spit out the records/HTML.
I want to use something like:

<xsl:if test="/root/ProductsToExclude/Product != ProductID">
(second query) ------- != -------------- node in first query/template.

I feel that inside this first template, it's 'looping' each product out but the second query values aren't all being checked, only the first value, is this correct?

How do I obtain the desired result of checking every ProductID from the template/query1 against ALL/EVERY value in the second query?

Thanks


EDIT:
OK, I have this so far: (close but no cigar)

<xsl:template name="ProductCell"> <=- uses first query-=
<xsl:variable name="Flag">
<xsl:for-each select="/root/ProductsToExclude/Product/ProductID"> <=-- this is from the second query-=
<xsl:if test=". = ProductID">
1
</xsl:if>
</xsl:for-each>
</xsl:variable>

<xsl:if test="$Flag = ''">.....show product....

This isn't working tho.. any ideas?

Have you verified that the data you want to check is being returned in the XML by turning on debug mode?