Hi! I have an XML file which has this node:

<ROOT>
 <TEST>
  <D0>000000000000000.00</D0>
  <D1>000000000000000.00</D1>
  <D2 />
  <D3 />
  <D4 />
  <D5 />
  <D6 />
  <D7 />
 </TEST>
</ROOT>

I need to access the values of D0 and D1. I came up with this code:
        Dim xml
    Set xml = Server.CreateObject("Microsoft.XMLDOM")
    xml.async = False
    xml.load (Server.MapPath("sample.xml"))

        Dim test
    test = xml.getElementsByTagName("TEST").item(0).text
    Set xml = Nothing

I am able to get this: 000000000000000.00 000000000000000.00

But this is not what I need. I need to get the values separately (i.e. array or something). How do I do this?

You can be more precise by using selectNodes or selectSingleNode methods, combined with XPath selection.

xml.selectSingleNode("/ROOT/TEST/D0").text gives value of the D0

xml.selectNodes("/ROOT/TEST/*") gives you a nodelist object containing all elements D0...D7 - u can use this like an array by accessing items by index number or using For Each varChildNode in theNodeList

Finally Microsoft.XMLDOM is very old version. Try one of these later versions instead:
MSXML2.DOMDocument.4.0
MSXML2.DOMDocument.3.0

hth
Phil

What are the requirements of MSXML2.DOMDocument.4.0/MSXML2.DOMDocument.3.0? msxml3.dll/msxml3.dll right? are these built in components? or do you have to install it first?

thanks for your help phil! i already found a solution...thanks again!

set test = xml.getElementsByTagName("test")
Set xml = Nothing

dim objChild
For Each objChild In test

if objChild.hasChildNodes() then
    do while (i<objChild.childNodes.length and flag=0)
        if objChild.childNodes(i).text="" then
            flag=1
        else
            response.write i&"-"
            response.write objChild.childNodes(i).text
        end if
        i=i+1
    loop
end if