JQuery DataTables - AJAX reloading how to catch when nothing is returned

Question

I am using a datatable and allow records to be deleted from the database. After deletion, I reload the table to display the recent changes. However, if I delete the last record from the database, null is returned by the AJAX call and does not update the datatable (it still displays the record that was just deleted).

My Call after the delete function is performed:

oTable.fnDraw();
oTable.fnReloadAjax();

The console error here is:

json.aaData is null
[Break On This Error] for ( var i=0 ; i<json.aaData.length ; i++ )

Is there a way to detect when nothing is returned from AJAX so that the datatable can detect that there are no records and display the 'datatable empty' message (i.e. No data available in table)?

JimmyJammed · Accepted Answer · 2011-12-29 20:41:18Z

1

Ok so the issue was on the server side, when my sql queries were empty it was returning NULL as the aaData['aaData'] value.

Just added this and now it returns as a table that is just empty:

if(mysql_num_rows($result)==0){
        $aaData = array();
        $aaData['aaData']='';
        echo json_encode($aaData);
        exit;
    }

answered Dec 29, 2011 at 20:41

JimmyJammed

9,72820 gold badges81 silver badges152 bronze badges

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

Comments

Diodeus - James MacFarlane · Accepted Answer · 2011-12-21 00:51:10Z

0

Put your JSON data in a wrapper, and have the wrapper tell you there's no data, instead of returning null:

{"data":[... your current data ...],"total":0,"success":true}

answered Dec 21, 2011 at 0:51

Diodeus - James MacFarlane

115k33 gold badges164 silver badges180 bronze badges

Comments

mutex · Accepted Answer · 2011-12-21 00:51:25Z

0

I suspect you need to look at your server side code and find why aaData is null. I use datatables and when there are no records the json generated is:

...,"aaData":[],...

and empty message displays fine.

answered Dec 21, 2011 at 0:51

mutex

7,7469 gold badges47 silver badges69 bronze badges

Collectives™ on Stack Overflow

JQuery DataTables - AJAX reloading how to catch when nothing is returned

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related