Jquery datatable integration error?

Question

I am integrating jquery datatable to my project. When call is made to service, some how following error is error thrown

cannot read property 'assorting' of undefined

Here is the code

Timeline

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script  src="js/jquery.dataTables.js"></script>

<body>

<script>

$(document).ready( function() {
  $('#example').dataTable( {
    "bProcessing": true,
    "bServerSide": true,
    "sAjaxSource": "URL",
    "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) {
    console.log(aoData);
      oSettings.jqXHR = $.ajax( {
        "dataType": 'json',
        "type": "POST",
        "url": sSource,
        "data": aoData,
        "success": fnCallback
      } );
    }
  } );
} );

</script>

<div id="dvContent">
 <table cellpadding="0" cellspacing="0" border="0"  id="example">

 </table>
</div>

</body>

Here is the Sample out put of the server

{"some":"yyy", "open":null, "program":1, "more":"must", "comment":000 }

where in your code you are trying to read assorting..paste that code.. — Rajat Singhal
– Rajat Singhal, Commented Nov 10, 2012 at 6:45
no I don't want asorting. I haven't done any coding for that. By default this error is comming — niran
– niran, Commented Nov 10, 2012 at 6:46
its not what u want..its where u've used it?? so that we can see whats wrong.. — Rajat Singhal
– Rajat Singhal, Commented Nov 10, 2012 at 6:48

Bumptious Q Bangwhistle · Accepted Answer · 2017-12-02 19:56:05Z

37

Your table needs a THEAD section and a TBODY section:

<table cellpadding="0" cellspacing="0" border="0"  id="example">
   <thead><tr><th>First Column</th><th>Second Column etc.</th></tr></thead>
   <tbody>
   </tbody>
</table>

Note: it's also important that your THEAD not be empty as dataTable requires you to specify the number of columns of the expected data as specified by <tr><th></th></tr>

edited Dec 2, 2017 at 19:56

answered May 1, 2013 at 11:03

Bumptious Q Bangwhistle

4,7692 gold badges36 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MoFlo · Accepted Answer · 2014-04-29 17:05:16Z

2

In addition to the point by @bumptious above, it's important to note that the THEAD section cannot be blank; dataTables requires the <tr><th>column1</th></tr> content as placeholder within the table.

answered Apr 29, 2014 at 17:05

MoFlo

5594 silver badges6 bronze badges

Comments

Harish · Accepted Answer · 2015-04-22 15:22:12Z

1

This error can also occur when you use "order" clause and refer to non-existing field/column.

answered Apr 22, 2015 at 15:22

Harish

911 gold badge2 silver badges10 bronze badges

Comments

Mohan · Accepted Answer · 2015-05-21 16:25:01Z

0

Thanks,

Table should have & section.

answered May 21, 2015 at 16:25

Mohan

7976 silver badges8 bronze badges

Comments

SwR · Accepted Answer · 2016-08-22 08:39:18Z

0

Make sure your table's number of data columns td is equal to header columns th.

answered Aug 22, 2016 at 8:39

SwR

6321 gold badge8 silver badges21 bronze badges

Collectives™ on Stack Overflow

Jquery datatable integration error?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related