Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

populating a node list

Help Please.
Hello XML'ers
I am pulling my hair out trying to figure out how to populate a NodeList object with all the YEARS from this following xml document.
I will pass the sFile variable to the object
I want all the "Survey year" nodes from the Structure Name

This is the VBA routine that i have.  I am already loaded the XML file
    Dim oYearNodeList As MSXML2.IXMLDOMNodeList
    Dim sfile As String 'FileSystemObject
   
    myXML.validateOnParse = False
   
    sfile = ActiveDesignFile.Name
    Set myXElem = myXML.documentElement


   
    On Error GoTo BADTHINGS
    Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='" & sfile & "']/Surveys[@year= " * "]
 
   
   
    Debug.Print "how"
BADTHINGS:
    MsgBox Error
End Sub



<?xml version="1.0"?>
<!DOCTYPE Bridge_Scour SYSTEM "Bridge_Scour.dtd">
<Bridge_Scour>
     <Structure Name = "uw1.dgn">
          <Surveys year="2000">
                <Survey>
                    <Entry><Station>0</Station> <Elevation>926.7</Elevation></Entry>
                    <Entry><Station>17</Station> <Elevation>925.1</Elevation></Entry>
          <Entry><Station>32</Station> <Elevation>922.7</Elevation></Entry>
                    <Entry><Station>47</Station> <Elevation>916.7</Elevation></Entry>
                    <Entry><Station>62</Station> <Elevation>911.6</Elevation></Entry>
                    <Entry><Station>100</Station> <Elevation>909.8</Elevation></Entry>
                </Survey>
          </Surveys>
          <Surveys year="2001">
                <Survey>
                    <Entry><Station>0.3</Station> <Elevation>123.47</Elevation></Entry>
                    <Entry><Station>0.4</Station> <Elevation>123.48</Elevation></Entry>
               </Survey>
          </Surveys>
     </Structure>
     <Structure Name = "uw2.dgn">
          <Surveys year="2001">
                <Survey>
                    <Entry><Station>0.5</Station> <Elevation>123.49</Elevation></Entry>
                    <Entry><Station>0.6</Station> <Elevation>123.50</Elevation></Entry>
               </Survey>
          </Surveys>
     </Structure>
</Bridge_Scour>


PLEASE HELP..

Thanks so much
If i could give a thousand points i would.

0
sherrick123
Asked:
sherrick123
2 Solutions
 
Pierre CorneliusCommented:
0
 
sherrick123Author Commented:
I have been able to get all the years BUT i want just the years for a certain structure WITHOUT going through a looping routine.  Their will be lots of years and i am concerned with processing time
0
 
Carl TawnSystems and Integration DeveloperCommented:
Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='" & sfile & "']/Surveys/@year")
0
 
Geert BormansCommented:
Hi sherrick123,
> Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='"
> & sfile & "']/Surveys[@year= " * "]

since we don't sem to get there the preceding-sibling way...

you can't use the '*' as a wildcard in XPath
just leaving that part out will give you all the surveys/@year

Set oYearNodeList = myXML.selectNodes("Bridge_Scour/Structure[@Name='" & sfile & "']/Surveys/@year")

will give you a list of years, not necessarily unique
you can then create an array of unique values from this nodeset
by looping over the nodeset and creatin a new item on the other array, if the value does not yet exist

I am still wondering why we can't get the preceding-sibling to work though...

Cheers!
0
 
Geert BormansCommented:
sherrick123,

oh man I am late....
ignore my previous message
(and after that this one as well :-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now