title: Get value of node from XML using loop
body: <p>Trying to loop though my XML data and assign to text fields. Not get a specific error but I am pretty sure it has something to do with the way I am referencing the data and assign it to the .text box. I am also having issues with getting the length of my xml so I know how many times to loop. Please Help. THANKS!</p>
  
  <p>first a summary of my XML: </p>
  
  <pre><code>&lt;Worksheet&gt;
     &lt;Row&gt;
      &lt;Data&gt;Last Name&lt;/Data&gt;
      &lt;Data&gt;First Name&lt;/Data&gt;
      &lt;Data&gt;Ext.&lt;/Data&gt;
     &lt;/Row&gt;
     &lt;Row&gt;
      &lt;Data&gt;Smith&lt;/Data&gt;
      &lt;Data&gt;Liz&lt;/Data&gt;
      &lt;Data&gt;103&lt;/Data&gt;
     &lt;/Row&gt;
     &lt;Row &gt;
      &lt;Data&gt;Johns&lt;/Data&gt;
      &lt;Data&gt;Jason&lt;/Data&gt;
      &lt;Data&gt;116&lt;/Data&gt;
     &lt;/Row&gt;
     &lt;Row&gt;
      &lt;Data&gt;Potts&lt;/Data&gt;
      &lt;Data&gt;Cheryl&lt;/Data&gt;
      &lt;Data&gt;131&lt;/Data&gt;
     &lt;/Row&gt;
  &lt;/Worksheet&gt;
  </code></pre>
  
  <p>Now the AS3 that should loop through and assign values from the XML into text fields:</p>
  
  <p><strong>//HAVING ISSUES GETTING THE LENGTH OF myXML</strong></p>
  
  <pre><code>                for (i = 0; i &lt; myXML.Worksheet.length(); i++){
  
                  trace(["in for loop" + i]);
                                   //Create new text_holder from linked MC
                  var item:text_holder = new text_holder();
                   //add text holder to stage
                  scroll_box.addChild(item);
  </code></pre>
  
  <p><strong>//NOW I WANT TO ASSIGN THE VALUES OF THE FIRST THREE DATA NODES IN THE LOOPS CURRENT ROW TO DYNAMIC TEXT FIELDS</strong></p>
  
  <pre><code>                        item.first_name.text = myXML.Worksheet.Row[i].Data[1];
                          item.last_name.text = myXML.Worksheet.Row[i].Data[0];
                          item.ext.text = myXML.Worksheet.Row[i].Data[2];
                              current_y_right = current_y_right  + 131;
                              item.x = current_x_right;
                              item.y = current_y_right;
  
                      }
  </code></pre>