title: how to capture the data in a selected row using jQuery DataTables
body: <p>I have this datatable setup:</p>
  <pre><code>$(document).ready(function() {
      $('#RectifiedCount').dataTable( {
          &quot;bJQueryUI&quot;: true,
          &quot;bProcessing&quot;: true,
          &quot;aLengthMenu&quot;: [[10, 25, 50, -1], [10, 25, 50, &quot;All&quot;]],
          &quot;bStateSave&quot;: true,
          &quot;sDom&quot;: '&lt;&quot;H&quot;if&gt;tr&lt;&quot;F&quot;lTp&gt;',
          &quot;aoColumns&quot;:[
                       {'sname':'count_id', 'sType':'numeric', 'bVisible':false},
                       {'sName':'count_type', 'sType':'string','bVisible':true},
                       {'sName':'count_date', 'sType':'date','bVisible':true},
                       {'sName':'count_count', 'sType':'numeric','bVisible':true},
                       {'sName':'count_notes', 'sType':'string','bVisible':true}
                       ],
          &quot;oTableTools&quot;: {
              &quot;sRowSelect&quot;: &quot;single&quot;,
              &quot;sSwfPath&quot;: &quot;media/swf/copy_cvs_xls_pdf.swf&quot;,
              &quot;aButtons&quot;: [ {sExtends :'select_none' , 'sButtonText':'Clear Selection'}],
              &quot;fnRowSelected&quot;: function(node){
                  var s=$(node).children();
                  if($(s[0]).text()=='Delivery') return ;
                  $('select[name=&quot;count_type&quot;]').val($(s[0]).text());
                  $('input[name=&quot;count_date&quot;]').val($(s[1]).text());
                  $('input[name=&quot;count_count&quot;]').val($(s[2]).text());
                  $('textarea[name=&quot;count_notes&quot;]').val($(s[3]).text());
              }
          },
          'sScrollX':'100%'
      });
  });
  </code></pre>
  <p>When I select a row, I want to copy the values of the cells of that row into some form fields that are named the same as the 'sName' attributes. I have 2 questions:</p>
  <ul>
  <li>is there a TableTools method for accessing the value of a cell in a selected row? Something like <code>node['sName_whatever'].value</code> would be nice.</li>
  <li>how can I get the value of the cells where bVisible=false?</li>
  </ul>
  <h1>ETA solution</h1>
  <p>(leaving out the unimportant stuff)</p>
  <pre><code>$(document).ready(function() {
      rctable=$('#RectifiedCount').dataTable( {
          &quot;aoColumns&quot;:[
                       {'sname':'count_id', 'sType':'numeric', 'bVisible':false},
                       {'sName':'count_type', 'sType':'string','bVisible':true},
                       {'sName':'count_date', 'sType':'date','bVisible':true},
                       {'sName':'count_count', 'sType':'numeric','bVisible':true},
                       {'sName':'count_notes', 'sType':'string','bVisible':true}
                       ],
          &quot;oTableTools&quot;: {
              &quot;sRowSelect&quot;: &quot;single&quot;,
              &quot;fnRowSelected&quot;: function(node){
                  aData = rctable.fnGetData(node); //nice array of cell values
                  if(aData[0]=='Delivery') return ;
                  $('select[name=&quot;count_type&quot;]').val(aData[0]);
                  $('input[name=&quot;count_date&quot;]').val(aData[1]);
                  $('input[name=&quot;count_count&quot;]').val(aData[2]);
                  $('textarea[name=&quot;count_notes&quot;]').val(aData[3]);            }
          }
      });
  });
  </code></pre>