I'm using SelectNodes from XMLDocument (In access 2003) in order to read all of the Nodes contained in the file, but I'm having some problems to get the second and third nodes in a loop.
When using this vb code, I receive two records of the first node ("//body2")
And go on to the rest of the xml, how do I get the individual values?
Aha, now it makes sense. What's happening is that you are using // in the xpath query.
Do the following and it should work, as it's selecting only the named node in nodeR, not the whole document.
So, fldName is being filled from <surname>, and fldNames is filled from <givenNames>?
Are the remaining fields filled with an empty string, or is it falling over as nodeR.selectSingleNode("//position") is Nothing?
0
smaysharAuthor Commented:
I am not sure that I understand your qustion, the records in the rst after running the code lokks like this:
NEATON LEISA PRINCIPAL 1 2145 07493153 Ffff SCHOOL
NEATON LEISA PRINCIPAL 1 2145 07493153 Ffff SCHOOL
insdeat of :
NEATON LEISA PRINCIPAL 1 2145 07493153 Ffff SCHOOL
OBAMA Barak TEACHER 1 2189........
it goes over the first node 2 times and contintue for the rest of the xml why ???
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Do the following and it should work, as it's selecting only the named node in nodeR, not the whole document.
For more information on how xpath works, have a look at this site:
http://www.w3schools.com/xpath/xpath_syntax.asp
Open in new window