server-side processing example with hidden row information

ak-d

Hi,

I have a problem with my page-buttons. I use the same code like the example with the only differnt that I use another SQL Syntax.

The pager show only

First Previous 1 Next Last

Showing 1 to 10 of 10 entries (filtered from 402 total entries)

Pls Help

allan

Hi ak-d,

Please refer to the documentation for what parameters your server-side script should be returning: http://datatables.net/usage/server-side

Using Firebug (etc) with the examples is also a good idea to see what is happening: http://datatables.net/examples/data_sources/server_side.html

My guess here is that your iTotalRecords and iTotalDisplayRecords returns are incorrect for the number of entries you have.

Regards,
Allan

ak-d

Hi Allan,

thx for your answer.

I get the correct number of entries from server_processing_details_col.php -> {"sEcho": 0, "iTotalRecords": 402, "iTotalDisplayRecords": 402, "aaData": ....

The name of my colums are not written in lower case, could that's the problem ?.
I also tried debugging tools in IE8 and Firebug. I can't find any errors. Very strange ....

allan

Hi ak-d,

I don't think that sEcho should ever be 0. Are you correctly echoing back sEcho that is sent from the client-side? It should be cast as an int as well for security reasons:

$sOutput .= '"sEcho": '.intval($_GET['sEcho']).', ';

Regards,
Allan

flaviusm

Hi,

I am using the example from the page http://www.datatables.net/examples/server_side/row_details.html. It works well in IE8, but in Firefox/3.5.7 it deletes the rows instead of showing the details.

Is there a problem with the example or with the library?

Thank you,
Flavius.

allan

Hi Flavius,

You might need to clear your browser's cache - it might has cached DataTables 1.5.6 and/or the old example code, which is a touch different (the change from iSortDir_ to sSortDir). I've just seen exactly that behaviour in Safari 4, and reloading fixed it for me. If that doesn't help, shout back :-)

Regards,
Allan

flaviusm

Allan,

For some reason it didn't work after I cleaned up the cache (both IE and FF). So I reinstalled FF and now it works.

Thanks a lot ,
Flavius.