title: How do I parse through this XML tree in VBScript?
body: <p>I'm trying to parse through the a XML tree in VB Script, but I'm unable to pull out the values I want. I'm would like to pull the name value (eg. <code>CHNG_REQT_NB</code> and <code>CHNG_REQT_DTL_CO</code>), however with the code I have below, I'm only able to get it to print out "column" and value associated with each, For example, with the below code and XML, it would print out as below:</p>
  
  <pre>
  column
  13389
  column
  /* NOTES */ 1) CR#145: New Code Table 
  </pre>
  
  <p>I would like it to print as</p>
  
  <pre>
  CHNG_REQT_NB
  13389
  CHNG_REQT_DTL_CO
  /* NOTES */ 1) CR#145: New Code Table
  </pre>
  
  <p>Could someone please point out where I'm going wrong? Below are my code and XML samples.</p>
  
  <pre class="lang-vb prettyprint-override"><code>Set objXMLDoc = CreateObject("Microsoft.XMLDOM") 
  objXMLDoc.Async = False 
  objXMLDoc.Load("result.xml")
  
  Set Root = objXMLDoc.DocumentElement 
  Set rowList = Root.GetElementsByTagName("row")
  
  For Each row In rowList
       handleNode(row)
  Next
  
  Sub handleNode(row)
      For Each elem In row.ChildNodes
          WScript.Echo elem.TagName
          WScript.Echo elem.Text
      Next
  End Sub
  </code></pre>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;resultsets&gt;
  &lt;resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
  &lt;row&gt;
  &lt;column name="CHNG_REQT_NB"&gt;13389&lt;/column&gt;
  &lt;column name="CHNG_REQT_DTL_CO"&gt;/* NOTES */ 1) CR#145: New Code Table&lt;/column&gt;
  &lt;/row&gt;
  &lt;/resultset&gt;
  &lt;/resultsets&gt;
  </code></pre>