Need to find a node

[Karthik01]

Hi,
i have written a VB script to find a node name in an XML.Now i need to search for that node name in another XML. How can i do it.
My XML looks like this

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly">
- <s:AttributeType name="HDR_HideTraneLogo" rs:number="1" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>
- <s:AttributeType name="HideTraneLogo" rs:number="2" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>
- <s:AttributeType name="HDR_NbrBlankPageHeaderSections" rs:number="3" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>
- <s:AttributeType name="NbrBlankPageHeaderSections" rs:number="4" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>
- <s:AttributeType name="HDR_TOPSS_Mode" rs:number="5" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>
- <s:AttributeType name="TOPSS_Mode" rs:number="6" rs:nullable="true" rs:writeunknown="true">
<s:dataType dt:type="string" dt:maxLength="50" rs:precision="50" />
</s:AttributeType>

My code,
Set objXMLSearchDocument = Sys.OleObject("Msxml2.DOMDocument.4.0")

objXMLSearchDocument.async = False


' Load the files created earlier

objXMLSearchDocument.setProperty "SelectionLanguage", _
"XPath"
Call objXMLSearchDocument.loadXML(strXML)

set objXMLRoot = objXMLSearchDocument.DocumentElement

Set objXMLSearchElements = objXMLSearchDocument.getElementsbytagname("'//s'")

What should i populate in the get elements by tagname to fetch a value from XML

[jkmyoung]

The Element name is not, s, rather it is Schema, or ElementType, or AttributeType, etc.. eg, <rs:Schema> and <s:Schema> would be 2 different types of nodes, but both with the same element Name Schema. The s: prefix ties these elements to a particular namespace.

I don't specifically know what elements you are looking for.
Try getElementsByTagName('Schema')

[Karthik01]

Hi,
Thanks for your response. i need further clarifications.
Supposing that i need to fetch the name "HDR_HideTraneLogo" from the following line,how can it be done.Do i need to create the XPATH from the root??

- <s:AttributeType name="HDR_HideTraneLogo" rs:number="1" rs:nullable="true" rs:writeunknown="true">


Also, getelementsbytagname('Schema') did not throw any error when it ran.But when i checked for the lenght of the object that fetched these nodes, Zero is what i can see.Any specific reasons why it did not work?? Kindly help me.

[jkmyoung]

You probably need to use the version of the function that takes in a namespace:
getElementsByTagName("Schema", "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882")