title: Easiest way to utilize coldfusion returned json object (from query)
body: <p>I've got a <code>CFC</code> thats returning a query object in JSON format, looks like this:</p>
  
  <pre><code>{
   "COLUMNS":["CMADDR","CMBILL","CMCRLIMIT","CMCRREVIEW","CMCRTERMS","CMCRUPDATE","CMCURR"],
   "DATA":[[1.2004856E7,3.2004856E7,0,"January, 01 1959 00:00:00","N\/30",null,"USD",null,false,false,false,"",0,"","US", ...],
          [2.2045505E7,3.2004583E7,4000,"January, 01 1959 00:00:00","1\/10N30",null,"USD",null,false,false....]]
  }
  </code></pre>
  
  <p><em>data has been shortened just for structure sake</em></p>
  
  <p>But I am given back a jSON object with columns &amp; data.</p>
  
  <p>What is the best way to access this data using jQuery? Excuse my inexperience, as in the past I've just used more simple structures, and I've usually defined them myself, this way the CFC returns this output to me and I'm forced to consume it and iterate through it with end result being a table of data.</p>
  
  <p>I've tried the following, but get undefined values so far:</p>
  
  <pre><code>// ajax calls .. this is on success..
  // ...
  function(data) {
      //alert('got data back! \n'+data);
      var obj = jQuery.parseJSON(data);
      $.each(obj, function(index, itemData) {
      $('#modal-table-listing &gt; tbody:last').append('&lt;tr&gt;' +
          '&lt;td&gt;[Select]&lt;/td&gt;' +
          '&lt;td&gt;'+ itemData.cmAddr +'&lt;/td&gt;' +
          '&lt;td&gt;'+ itemData.adName +'&lt;/td&gt;' +
          '&lt;td&gt;'+ itemData.adState +' - '+ itemData.adCity +' - '+ itemData.adZip +'&lt;/td&gt;&lt;/tr&gt;');
      });
  
      console.log(obj);
  }
  </code></pre>
  
  <p>I'd love to use the <code>columns</code> object to reference the relevant data, if that makes sense.</p>