XPath woes [vb.net]

[ArmsTom]

I've been playing around with xml for a couple days, so I have no idea what
I'm doing yet :). Be gentle.
Ok, here's what I have...

================================
Do while xmlIter_Records.MoveNext

Dim i As Integer = xmlIter_Records.Current.GetAttribute("id", "")

Dim xmlIter_MovieINfo As XPath.XPathNodeIterator =
xmlXPNav.Select("/Records/Record[@id='" & i & "']/MovieInfo/*")

Do while xmlIter_MovieInfo.MoveNext
...
loop

Loop
=================================
The id above will always be something like "001","002",etc

When using the above, I cannot get the children of /MovieInfo, BUT if I
remove [@id='" & i & "'] with [@id='001'] I get the results I want, which
is to say, the "MovieInfo" children.

Why does that happen? I just don't get it :).

Also, maybe someone can tell me a better way to do this:

Currently, I select each <Record>, get the "id" and create another iterator
that I use the xpath expr "/Records/Record[@id='"id"']". Forgive me if you
already figured that out from the above bit of code. Is there anyway that
I can do this, without two iterators? I know there is.

[Bjoern Hoehrmann]

* ArmsTom wrote in microsoft.public.dotnet.xml:

Dim i As Integer = xmlIter_Records.Current.GetAttribute("id", "")

Dim xmlIter_MovieINfo As XPath.XPathNodeIterator =
xmlXPNav.Select("/Records/Record[@id='" & i & "']/MovieInfo/*") The id above will always be something like "001","002",etc

But an Integer does not have leading zeros, thus your expressions is
e.g.

...[@id = '1']...

not

...[@id = '001']...

You need to add those leading zeros again or avoid the use of the
Integer data type (i.e., use a string).

[Oleg Tkachenko]

Bjoern Hoehrmann wrote:

You need to add those leading zeros again or avoid the use of the
Integer data type (i.e., use a string).

Or use only Interger type, e.g.
xmlXPNav.Select("/Records/Record[@id=" & i & "]/MovieInfo/*")
(note absent apostrophes).
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[ArmsTom]

Thanks for pointing that out.

Bjoern Hoehrmann <bj****@hoehrmann.de> wrote in news:3f6ee9ce.811582163
@news.bjoern.hoehrmann.de:

But an Integer does not have leading zeros, thus your expressions is
e.g.

...[@id = '1']...

not

...[@id = '001']...

You need to add those leading zeros again or avoid the use of the
Integer data type (i.e., use a string).