Search

server-side processing comes into play is when you have

and it therefore naturally plays well with Javascript libraries

the video does not play straight away and only

would still come into play!

in the pane then play around with the following.

example allows you to "play" with the various searching

top left (CSS also plays a part). The simplest

I am using Play! Framework application. The datatable

jEditable and KeyTables to play well. On pushing enter,

Hi again acts7seven, Have you looked at the example section, since some, like this one, may give clues. If you've tried that already, it would be worth creating a live example of your code as it would help us to understand the problem. Cheers, Colin

Thanks for posting back - I haven't used dojo myself so I can't really comment much about that, but I'm interested to see the change you had to make and see what changes, if any, should be made in DataTables core. As far as I am aware its UMD loader is quite generic. Allan

Thanks for the quick and friendly answers. I'm willing to be my extra draw() won't be needed once I follow your suggested solution.

Hi Allan, also the latest version does not work as expected. If you need anything else, just let me know. Cheers, Peter

When you enable scrolling DataTables splits the table up into multiple parts (in order to have the header, body and footer all scrolling as expected). For example: [code] $(document).ready(function(){ alert( $('.datatable').length ); $('.datatable').dataTable({ sScrollX: "100%" )}; alert( $('.datatable').length ); }); [/code] You should get 1 then 2 or 3 (depending on your table setup). So what needs to be done is to use a more selective selector in the second case. Or to store a reference to the original returned object. Allan

That's what is was. Fixed now :)

I've done quite a bit of troubleshooting and research here (my second FULL day using dataTables), trying many ideas that other folks mentioned. This may help, so I'm posting here, and perhaps someone can teach me something, too! In summary, when I had bPaginate set to false and I used ColVis to select and deselect columns, as mentioned before, it must have been re-calling the AJAX (oh... serverside data in mysql) back to the database every time to re-render the table. I narrowed it down to bPaginate specifically by commenting/uncommenting things... and that would still show my the pagination numbers and stuff, which I didn't like... and then I found an sDom (no matter how long I stare at that I still haven't figured it out completely (yeah, I read about it, too) !!!! lol) that worked... Anyway... here it is... real basic so far: [code] @import "./media/css/demo_table.css"; @import "./media/css/demo_table_jui.css"; @import "./extras/ColVis/media/css/ColVis.css"; .ColVis { float: left; margin-bottom: 0 } .dataTables_length { width: auto; } <!-- this next line is an older jquery 1.8.2 and I cannot seem to make various things work without it!! --> <script type="text/javascript" language="javascript" src="./media/js/jquery.js"></script> <script type="text/javascript" language="javascript" src="./media/js/jquery.dataTables.1.9.4.js"></script> <script type="text/javascript" charset="utf-8" src="./extras/ColVis/media/js/ColVis.1.0.8.js"></script> $(document).ready(function() { $('#example').dataTable( { "sScrollY": "600px", "bScrollCollapse": true, //"bPaginate": false, "bDeferRender": true, "bStateSave": true, "bJQueryUI": true, "sDom": 't', "bProcessing": true, "bServerSide": true, "sAjaxSource": "./server_processing.php", }); $("div.toolbar").html(" insert DrawLegendTable here. "); }); and then the table and header and all that here [/code] so... about 3000 rows and 17 columns... and when I try to use ColVis to select/unselect columns, it's REAL slow... unusably slow. So the fix, for me, is: [code] //"bPaginate": false, "sDom": '<"H"Cfr>t<"F"iS>', [/code] Mainly the sDom excluding the "l" I hope that helps someone!!! I also tried using the latest NIGHTLY's and stuff... ColVis changed some functionality (clicking backdrop to close) I didn't like so I reverted back. oh - and THANKS ALAN! I'm loving what I'm seeing so far!

Hi, I'm using asStripeClasses to class every three rows repeatedly with the final three rows receiving specific attention. It appears that the asStripeClasses only works correctly for the final three rows if iDisplayLength is disabled or set to All. Can someone confirm that these work together? Thanks.