SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    parse xml with sub child nodes

    Good morning.

    I have the next xml file with sub childs, and I want to read them for populate the data into a table. Right now, I know how to do it in a simple way, with childnodes, but I really dont know how to achieve it for getting the sub childnodes.

    <Result>
    <Record id="000231">
    <AC_NPD/>
    <Name>Company1</Name>
    <AC_CPR>00003</AC_CPR>
    <AC_ALM>00</AC_ALM>
    <AC_FEC>12/01/2007</AC_FEC>
    <AC_LNA ncols="6">
    <Row>
    <Column>000084</Column>
    <Column>1.230</Column>
    <Column/>
    <Column/>
    <Column/>
    <Column/>
    </Row>
    </AC_LNA>
    <AC_FSE>12/01/2007</AC_FSE>
    <AC_AV/>
    <AC_UFH ncols="3"/>
    </Record>
    </Result>

    Now, I paint the table with the results, using this script:

    Code:
     <script>
         if (window.XMLHttpRequest)
         {// code for IE7+, Firefox, Chrome, Opera, Safari
         xmlhttp=new XMLHttpRequest();
          }
        else
         {// code for IE6, IE5
         xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
          }
    
         xmlhttp.open("GET","xml/pruebas/resp2.asp",false);
         xmlhttp.send();
         xmlDoc=xmlhttp.responseXML; 
    
    
         document.write("<table class='table table-striped table-condensed table-bordered'  id='example'>");
        document.write("<thead>");
            document.write("<tr class='odd gradeX'>");
    	  document.write("<th>Sale</th>");
            document.write("<th>Name</th>");
            document.write("<th>Date</th>");
    		document.write("<th>Date Sale</th>");
    		document.write("<th>Item</th>");
    		document.write("<th>Quantity</th>");
    		document.write("<th class='hidden-phone'>Price</th>");
    		document.write("<th class='hidden-phone'>Total</th>");
    		document.write("<th>Sale Item</th>");
    		document.write("<th>Button</th>");
           document.write("</tr>");
           document.write(" </thead>");
        var x=xmlDoc.getElementsByTagName("Record");
    
        for (i=0;i<x.length;i++)
         { 
      
      
         document.write("<tr>");
         document.write("<td>");  document.write("</td>");
         document.write("<td>");  document.write(x[i].getElementsByTagName("Name")[0].childNodes[0].nodeValue);  document.write("</td>");
         document.write("<td>");  document.write(x[i].getElementsByTagName("AC_FEC")[0].childNodes[0].nodeValue);  document.write("</td>");
         document.write("<td>");  document.write(x[i].getElementsByTagName("AC_FSE")[0].childNodes[0].nodeValue);  document.write("</td>");
         document.write("<td>");   document.write("</td>");
         document.write("<td>");   document.write("</td>");
         document.write("<td>");   document.write("</td>");
         document.write("<td>");  document.write("</td>");
    
    
        document.write("<td> <a data-toggle='modal' class='btn' href='sale.asp?&number=");     document.write(x[i].getElementsByTagName("AC_FEC")[0].childNodes[0].nodeValue);    document.write("' data-target='#myModal'>  My Sale  </a> ");                document.write("   </td>");
    
         document.write("</tr>");
         }
        document.write("</table>");
        </script>
    So, if anyone knows how to get the sub child node i would be very gratefully.

    Best regards.

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,254
    Mentioned
    113 Post(s)
    Tagged
    1 Thread(s)
    This looks suspiciously like a homework assignment, which we're not going to do for you.

    BUT doing a google/bing search for "javascript childnodes" should get you what you seek...
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •