Answers

• Daimian Posts: 62Questions: 1Answers: 15

  July 2014

  My knowledge of 1.9.4 is a bit rusty... But I think your issue is with the mRender. Try removing it. If it works then I would try adding the mRender to the aoColumns section for the column it is needed.
• bheksta Posts: 6Questions: 1Answers: 0

  July 2014 edited July 2014

  Even before mRender - it never worked...
  it only accepts JSON array dat NOT JSON objects

  I added "mRender" way long after all my tries to display JSON objects data list have falied.
  It throws this error:
  " DataTables warning (table id = 'xxxxx'): Requested unknown parameter '0' from the data source for row 0 "

  BUT if I return JSON data as array ({"data":[{0:"Testing", 1:"PHP"},{....}]}) - it works fine

  this fails :
  {"data":[{"topic":"Testing", "Subject":"PHP"},{....}]}

  -- what is it that it does like about named JSON objects
• Daimian Posts: 62Questions: 1Answers: 15

  July 2014 Answer ✓

  Try changing data to mData.

  I was digging through my old Datatables pages and one of my 1.9.4 pages used mData.
• bheksta Posts: 6Questions: 1Answers: 0

  July 2014

  Thank you ! Thank You ! Daimian
  mData is exactly what it required.
• allan Posts: 65,263Questions: 1Answers: 10,819 Site admin

  July 2014

  Yup - the camelCase notation was introduced in 1.10, which the currency documentation reflects.

  If you need to use the old version of the library the legacy documentation is still available (although I would obviously recommend upgrading).

  Allan
• bheksta Posts: 6Questions: 1Answers: 0

  July 2014

  Hi Allan

  On change event of select input > I want to repopiulated my table with new data based on the selected value from the drop-down:

  HTML

  ** It olny works for the first time if you select the value from dropdown

  BUT this doesnt seem to work
  $('#myTableId').dataTable().fnClearTable();

  How should I do it ?
• allan Posts: 65,263Questions: 1Answers: 10,819 Site admin

  July 2014

  Please link to a test case showing the issue so we can debug it.

  Allan
• bheksta Posts: 6Questions: 1Answers: 0

  July 2014 edited July 2014

  I have this HTML :

                                    <<select id="selectError" class="form-control" data-rel="chosen">
                                      <option>Option 1</option>
                                      <option>Option 2</option>
                                      <option>Option 3</option>
                                      <option>Option 4</option>
                                      <option>Option 5</option>
                                    </select>
  
  
                          <table id="mytable" class="table table-striped table-bordered bootstrap-datatable">
  
                        </table>            
                      </div>
  

  i have this " <<" ..so it wont create html on this pot >>
  JS:

  $('#selectErrorl').change( function() {
  var selectedVal = '';

          //alert( $('#mytable').text().length ); -- my way of check if there is html content
  
          if ( parseInt( $('#mytable').text().length ) > 18 ){
              //$('#mytable').dataTable().fnClearTable(); --doesnt work
              $('#mytable').dataTable().fnDestroy();  - works         
          }       
  
          selectedVal = $(this).val();
  
          if (selectedVal != '' )   
              fnStatsSubsBilledReport( selectedVal, '' ); 
  });