Populate Select box from AJAX WDDX

I don't believe the cfc code is important as I know that I am getting return data from the server (using a packet sniffer)

I can either return a wddx packet  (as above)

or an array...


        qr =  new Array();
qr[0] =  new Array();
qr[0][0] = "tre_A";
qr[0][1] = "Tremblay, Alice";
qr[1] =  new Array();
qr[1][0] = "tre_A";
qr[1][1] = "Trel, Ann";
qr[2] =  new Array();
qr[2][0] = "tre_A";
qr[2][1] = "Trent, Alex";
 
Again both are seen by the returning page.

using the wddx, nothing happens

using the array firefox gives me a js error at

     qr =  new Array();
-----^

I'll be out of computer reach til Oct. 2 when I will get back to this...

does this work for you?

function findCustomer_response(result) {

       // test if result is returned - should indicate that it is an xml doc object
       // alert(result);

      var rowCount = result.getElementsByTagName('recordset')[0].getAttribute('rowCount');
      var fields = result.getElementsByTagName('field');
      var customers = [];
      var r;
      var f;
      var fieldName;
      
      for (r = 0; r < rowCount; r++) {
            customers[r] = new Object();
            for (f = 0; f < fields.length; f++) {
                  fieldName = fields[f].getAttribute('name');
                  customers[r][fieldName] = fields[f].childNodes[r].childNodes[0].data;
            }
      }

      var mySelect = document.getElementById('mySelect');
      mySelect.options.length = 0;
      for (r = 0; r < rowCount; r++) {
            mySelect.options[r] = new Option(customers[r]['CUSTNAME'],customers[r]['CUSTOMERID']);
      }
}

SidFishes:

Any luck with the response I posted?

Hi Daniel,

sorry for the delay in relpy

still not getting too far...here's waht I have so far

<script type="text/javascript">
   function findCustomer_request(){
         //This is the ajax call using jsmx
       param = 'CustomerID='+document.getElementById('CustomerID').value;
       http('POST','com/customermanager.cfc?method=getCustomerInfoFromSearch',findCustomer_response,param);
   }

function findCustomer_response(obj) {

       // test if result is returned - should indicate that it is an xml doc object
     
//****NOTE: alert(obj); does not work however the following does      

        alert(obj.custname[0]);
        alert(obj.customerid[0]);

// the following bit doesn't seem to do anything although no error is thrown

     var rowCount = obj.getElementsByTagName('recordset')[0].getAttribute('rowCount');
     var fields = obj.getElementsByTagName('field');
     var customers = [];
     var r;
     var f;
     var fieldName;
     
     for (r = 0; r < rowCount; r++) {
          customers[r] = new Object();
          for (f = 0; f < fields.length; f++) {
               fieldName = fields[f].getAttribute('name');
               customers[r][fieldName] = fields[f].childNodes[r].childNodes[0].data;
          }
     }

     var mySelect = document.getElementById('mySelect');
     mySelect.options.length = 0;
     for (r = 0; r < rowCount; r++) {
          mySelect.options[r] = new Option(customers[r]['CUSTNAME'],customers[r]['CUSTOMERID']);
     }
}


      
</script>
 <fieldset>
    <legend>Enter a Name and submit.</legend>
    <p> <input id="CustomerID" type="text">
<input type="button" value="Find Customer" onclick="findCustomer_request();"></p>
<select name="mySelect" id="mySelect">
</select>      
      
</fieldset>

The data returned (checked via ieInspector) is

<wddxPacket version='1.0'>
<header/>
      <data>
            <recordset rowCount='4' fieldNames='CUSTOMERID,CUSTNAME' type='coldfusion.sql.QueryTable'>
                  <field name='CUSTOMERID'>
                        <string>TRE_B00001</string>
                        <string>TRE_B00002</string>
                  </field>
                  <field name='CUSTNAME'>
                        <string>Tremblay, Bill</string>
                        <string>Trent, Bonnie</string>
                  </field>
            </recordset>
      </data>
</wddxPacket>


Any thoughts?

btw...I've edited the returned data for readability...the wddx string returned is actually on one line with no formatting or spaces between tags..(in case that matters)