Xpath with multiple values..

[Frano Hartman]

Is is possible to use XPath with multiple values like in SQL Queries (AND
Clause).For example:

If I have xml:
<rows>
<row code=1/>
<row code=2/>
<row code=3/>
<row code=5/>
<row code=6/>
<row code=7/>
<row code=100/>
</rows>

Now I want only to select rows 1,2,3 an 100
XPath("rows/row[@code='1' and @code='2' and @code='3' or @code='100']").
I tryed like this above, but I got nothing.
Any examples.
Regards.

[Keith Patrick]

Try using ORs all the way. An AND situation is impossible here because no
code can be 1 and 2 and 3 simultaneously

[Frano Hartman]

ORs works!!. (I forgot XPath is case sensitive it must be or not OR).
Do you know is this a good aproach to filter a xml if we have a 1000 rows,
we might
have a huge XPath expression, hundreds of ORs. Will this be slow solution?

"Keith Patrick" <ri*******************@nospam.hotmail.comwrote in message
news:e$**************@TK2MSFTNGP04.phx.gbl...

Try using ORs all the way. An AND situation is impossible here because no
code can be 1 and 2 and 3 simultaneously

[Keith Patrick]

I think you should be able to use lower-case "or", but the key is to get rid
of all the "and"s.
If you have thousands of inclusions but, say, few exclusions, then I'd
reverse the logic and use NotEquals ("&lt;&gt;", IIRC) coupled with "and"s.
Or, if you are filtering on numbers, I'd recommend trying to filter on
ranges (less than 20 but greater than 5, for example)