jQuery DataTables iTotalDisplayRecords is 0 when not using any filtering

jQuery DataTables iTotalDisplayRecords is 0 when not using any filtering

SteveSmithSteveSmith Posts: 6Questions: 3Answers: 0
edited June 2014 in Free community support

I'm following the DataTables + Oracle example at https://datatables.net/development/server-side/php_oracle.

My results look like:

{"sEcho":0,"iTotalRecords":"272364","iTotalDisplayRecords":0,"aaData":[]}

Why is my iTotalDisplayRecords 0 when I'm not using any filtering?

Thanks

Steve

Answers

  • SteveSmithSteveSmith Posts: 6Questions: 3Answers: 0
    edited June 2014

    I've enabled PHP error reporting and I'm shown:

    Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in /var/www/portal/server_processing.php on line 223

    Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in /var/www/portal/server_processing.php on line 224

    Warning: oci_execute(): ORA-30485: missing ORDER BY expression in the window specification in /var/www/portal/server_processing.php on line 250

    Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in /var/www/portal/server_processing.php on line 252

    Warning: oci_execute(): ORA-30485: missing ORDER BY expression in the window specification in /var/www/portal/server_processing.php on line 271

    Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in /var/www/portal/server_processing.php on line 274
    {"sEcho":0,"iTotalRecords":"272440","iTotalDisplayRecords":0,"aaData":[]}

    This is using the Oracle example at https://datatables.net/development/server-side/php_oracle. Why are there so many errors in it?

  • SteveSmithSteveSmith Posts: 6Questions: 3Answers: 0

    Someone to help, no ?

This discussion has been closed.