«

Consider the following XML

<?xml version="1.0" encoding="UTF-8"?>
<Root>
<Data>
<ID>1005</ID>
<Reference>
<Reference>ABC</Reference>
<Country>UK</Country>
</Reference>
<Reference>
<Reference>123</Reference>
<Country>USA</Country>
</Reference>
</Data>
</Root>


Using XPath, I would like to: Select the value of the Reference Node,
Where the ID = 1005, And the Country is USA. The value of the node
would therefore be 123.

I'm not great with XPath, but had a go and got it completely wrong:
XPath = "//Data/[ID ="1005"]/../Reference/[Country="USA"]/Reference"

I'd be ever so grateful if someone can help out with this XPath!

Cheers
Simon


(If its any help, I'm using vs.net 2005 and trying to populate an
XPathNodeIterator using XPathNavigator.Select)

Hello,

> Consider the following XML
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Root>
> <Data>
> <ID>1005</ID>
> <Reference>
> <Reference>ABC</Reference>
> <Country>UK</Country>
> </Reference>
> <Reference>
> <Reference>123</Reference>
> <Country>USA</Country>
> </Reference>
> </Data>
> </Root>
> Using XPath, I would like to: Select the value of the Reference Node,
> Where the ID = 1005, And the Country is USA. The value of the node
> would therefore be 123.
>
> I'm not great with XPath, but had a go and got it completely wrong:
> XPath = "//Data/[ID ="1005"]/../Reference/[Country="USA"]/Reference"

Should be something like /Root/Data[ID='1005']/Reference[Country='USA']/Reference

Square brackets should apply to the node you're selecting, rather than go
as an independent path element.

BTW it's a logical error to have an element named “Reference” take part as
a grouping node at one place and as a value holder in another. That is, the
semantics should be consistend per element name throughout the document.
One of them'd better be renamed.

(H) Serg

"Serge Baltic" <baltic-@hypersw.net> wrote in message
news: om...
> Hello,
>
> > Consider the following XML
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <Root>
> > <Data>
> > <ID>1005</ID>
> > <Reference>
> > <Reference>ABC</Reference>
> > <Country>UK</Country>
> > </Reference>
> > <Reference>
> > <Reference>123</Reference>
> > <Country>USA</Country>
> > </Reference>
> > </Data>
> > </Root>
> > Using XPath, I would like to: Select the value of the Reference Node,
> > Where the ID = 1005, And the Country is USA. The value of the node
> > would therefore be 123.
> >
> > I'm not great with XPath, but had a go and got it completely wrong:
> > XPath = "//Data/[ID ="1005"]/../Reference/[Country="USA"]/Reference"
>
> Should be something like
/Root/Data[ID='1005']/Reference[Country='USA']/Reference
>
> Square brackets should apply to the node you're selecting, rather than go
> as an independent path element.
>
> BTW it's a logical error to have an element named "Reference" take part as
> a grouping node at one place and as a value holder in another. That is,
the
> semantics should be consistend per element name throughout the document.
> One of them'd better be renamed.
>


Whilst I agree that naming a child element using the same name as the parent
is a little odd. In what way is it a 'Logical error'? Where can these
logic rules be found?

--
Anthony Jones - MVP ASP/ASP.NET

Thanks very much guys. I wasn't far off, but now understand where I
went wrong!

Merrry Christmas,

Simon