XPath filter on multiple attributes

[anxauto]

I have the following XML:

<?xml version="1.0" encoding="UTF-8"?>
<SETTINGS>
<DATABASE NAME="DEMO" DESCRIPTION="Demo database">
<USER NAME="arnaud" />
</DATABASE>
<DATABASE NAME="TEST" DESCRIPTION="Test database">
<USER NAME="peter" DEFAULT="1" />
<USER NAME="arnaud" />
</DATABASE>
</SETTINGS>

What I want is to get the <DATABASEnode where the <USER
NAME="arnaud" DEFAULT="1">. So in the above XML there is non. But I
use the following XPath statement:

DATABASE[USER/@NAME = 'arnaud' and USER/@DEFAULT = '1']

And <DATABASETEST is returned. I expect that there is nothing to be
returned.

What do I wrong, I am new with XPATH.

Regards
Arnaud

[Martin Honnen]

an*****@gmail.com wrote:

DATABASE[USER/@NAME = 'arnaud' and USER/@DEFAULT = '1']

And <DATABASETEST is returned. I expect that there is nothing to be
returned.

You want
DATABASE[USER[@NAME = 'arnaud' and @DEFAULT = '1]]

That way the filter filters on one USER element having those attribute
values while your attempt simply checks that there is one USER with NAME
attribute being 'arnaud' and a (further) USER with DEFAULT attribute
being '1'.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[anxauto]

Thanxs, it works great.

On 12 apr, 18:11, Martin Honnen <[e-mail]:

[e-mail] wrote:

DATABASE[USER/@NAME = 'arnaud' and USER/@DEFAULT = '1']

And <DATABASETEST is returned. I expect that there is nothing to be
returned.

You want
DATABASE[USER[@NAME = 'arnaud' and @DEFAULT = '1]]

That way the filter filters on one USER element having those attribute
values while your attempt simply checks that there is one USER with NAME
attribute being 'arnaud' and a (further) USER with DEFAULT attribute
being '1'.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/