XSL Using AND/OR

[Silvinho]

Im new to xml/xsl and i wanted to know if is posible to filter a for each query on more than one field like SQL using AND/OR values.

ie: in SQL you could write:
WHERE Country = 'France' AND Price > 30

but in xsl i cant see how to do a similar thing:
<xsl:for-each select="/PRODUCT/RECORD[AUTHOR='Test']">

Im not even sure if it is possible and if it is i cant seem to find anyhing about it???

Any help would be appreciated.

 

[k5tm]

Yes you can do this.

You will want to use an XPath Predicate. You can find a small tutorial here.

Tom Morrison

http://www.liant.com

 

[tsuji]

Imagine this data base.
[tt]
<xsl:for-each select="/PRODUCT/RECORD[@AUTHOR='Sartre' [highlight]or[/highlight] @CLASSIFICATION='Existentialism'][highlight]|[/highlight]/PRODUCT/RECORD[@SUBJECT='Drama' [highlight]and[/highlight] number(@PRICE) &lt; 20]">
[/tt]