Code

Re: Iterating through repeating sections

sshines — Tue, 15 Sep 2009 16:48:08 GMT

Thank you that worked! I knew it was something simple. I have been struggling with this for 3 days now and I could not find any documentation out there to explain what I was trying to do.

You are the best. Thank you.

Re: Iterating through repeating sections

Hilary Stoupa — Tue, 15 Sep 2009 16:32:15 GMT

Hi:

It is your XPath in this line:

junk = oNode.selectSingleNode("/dfs:myFields/dfs:dataFields/d:Employee/d:EmpEmergContacts/@EmergFirstName").text

You should use a relative XPath, like:

junk = oNode.selectSingleNode("@EmergFirstName").text

Iterating through repeating sections

sshines — Tue, 15 Sep 2009 15:24:24 GMT

HELP! I have been over this code a million times and cannot figure out what I am doing wrong. I have a repeating section. I can retrieve the data from the first section, but cannot retrieve the data from the second section. What am I missing?

Dim oNodes As IXMLDOMNodeList

Dim oNode As IXMLDOMNode

Dim i As Integer

Dim junk As String

oNodes = thisXDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:Employee/d:EmpEmergContacts")For i = 0 To oNodes.length - 1

oNode = oNodes.nextNode

If Not (oNode Is Nothing) Then

junk = oNode.selectSingleNode("/dfs:myFields/dfs:dataFields/d:Employee/d:EmpEmergContacts/@EmergFirstName").text

End If