XPath Query (Multiple Parameters)

[Ash]

Hi,

Using this sample XML ......


<Data>
<House>
<Location> London </Location>
<Type> Detached </Type>
<Value> 200,000 </Value>
</House>
<House>
<Location> London </Location>
<Type> Flat </Type>
<Value> 100,000 </Value>
</House>
</Data>


Is it possible to generate an xpath query which will locate all house nodes
which have a location = "London" and Type = "Flat".

Regards

Ash.

 

[Herfried K. Wagner [MVP]]

<Data>
<House>
<Location> London </Location>
<Type> Detached </Type>
<Value> 200,000 </Value>
</House>
<House>
<Location> London </Location>
<Type> Flat </Type>
<Value> 100,000 </Value>
</House>
</Data>

Is it possible to generate an xpath query which will locate all house
nodes
which have a location = "London" and Type = "Flat".

Untested (!):

"//Data/House[@Location='London' and @Type='Flat']"

 

[Arne Janning]

Hi Ash!

Using this sample XML ......


<Data>
<House>
<Location> London </Location>
<Type> Detached </Type>
<Value> 200,000 </Value>
</House>
<House>
<Location> London </Location>
<Type> Flat </Type>
<Value> 100,000 </Value>
</House>
</Data>


Is it possible to generate an xpath query which will locate all house
nodes
which have a location = "London" and Type = "Flat".

Herfried's solution works for selecting attributes, not the value of
elements.

If you want to select elements (like in your example):

//Data/House/Location [normalize-space(string()) = 'London']/../Type
[normalize-space(string()) = 'Flat']/..

I used normalize-space() to make the XPath-Query work with " London " or
"London".

Cheers

Arne Janning

 

[Herfried K. Wagner [MVP]]

Herfried's solution works for selecting attributes, not the value of
elements.

Ooops... Yes, you are absolutely right... I should definitely take more
sleep...