xml/dom/vbscript confused about selectNodes()
Posted on 2004-09-12
I want to write a function that initially will print out values of my xml file. I only want to print a certain part of the document so I use a selectNodes() call with some xpath syntax that maybe incorrect. Here is my xml document structure
<network_drive id_number="0" drive_letter="X:" old_mapping="\\server1\files2" new_mapping="\\server2\files2" />
<network_drive id_number="1" drive_letter="Y:" old_mapping="\\server2\file\test" new_mapping="\\server1\file\test"/>
so I am trying to print out the lines inbetween <Network_Drives> to get something like this:
The output could be on a single line or spread over multiple lines I just want to access each <network_drive>'s data and be able to store it into a variable eventually. First step would be printing out the data so I know its there.
I do not really even need the descriptions (drive_id, letter) all I want to do is spit out the data (o,x: etc..)
So I have this vbscript going right now
path = "C:\myfile.xml"
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
'Set xmlDoc = CreateObject("Msxml2.DOMDocument.4.0")
WScript.Echo "xml document loaded"
Set NodeList = objXMLDoc.documentElement.selectNodes("//Changes/Network_Drives")
WScript.Echo "Length " & NodeList.length
For Each Node in NodeList
My output right now is:
xml document loaded
And nothing prints from my loop.....(which I dont understand)
Can anyone help me out with my vbscript code to accomplish my desired output?