Search

i hope this will help. if not i will post the code.

datatable 1 and datatable 2 are completely different tables in html/datatables. it sounds like they will be completely different tables in the database as well. table 1 lists all orders table 2 allows you to list all parts of an order (all rows in table 2 that have a reference in some field to an order number) the call to oTable2.fnFilter() would be in whatever handler you are using to detect the user clicking on a row in oTable1. likely it is not specified within the initialization object of table1, but something like: [code] $(document).ready( function () { oTable1 = $('#table1').dataTable( // .... ); oTable2 = $('#table2').dataTable( // .... ); $('#table1 tbody tr').live('click', function() { // find the order number (I'm assuming it's in column 0 of every row) aData = oTable1.fnGetData(this); sOrder = aData[0]; // filter table 1 with this order number (assuming order number is in col 4 of table 2) oTable2.fnFilter(sOrder, 4); }) });[/code]

fbas: That is very unfortunate if i cannot do that. I am converting a different table implementation that supports this, and it would be a show stopper if i cant hack datatables to do this. what about my original idea of adding a 3rd 1px high header row with the column widths i require? This will probably break sort listener binding, but i can probably fix that by manually binding the sort listeners via the sort API.

Yes, well I'm a duffer, aren't I? It's all in the "processing" functionality built in to Datatables already. Works beautifully.

Hi allan, thanks for your suggestion, but I have solved it (my problem) with a differnet approach, I simply added a function call in the dataTables code itself [code] U=function(){g._iDisplayStart=(this.innerHTML*1-1)*g._iDisplayLength;m(g);PageChanged(this.innerHTML*1-1);return false} [/code] in my other js file I have the function: [code] function PageChanged(target) { alert('new Target' + target); } [/code] Since you took the time to post a solution, I tested it, no success. Is it possible that two 'click' events are the problem? if I use: [code] $('.paging_full_numbers').unbind('click').bind('click', function () { alert('click'); }); [/code] I get the alert message, but of course the page will not be chnaged :)

Great it works fine , but now I am stuck on some other issue , I have applied a css class 'sorting_1' to td of table , but they are visible in first page only var oDataTable=$('#jobs').dataTable(); oDataTable.fnSort( [[2,"desc"]]); // call the sort $('#jobs td').addClass('sorting_1'); But how can I add this code for paging button, as well as select change [10/20/....] $('#jobs td').addClass('sorting_1

Yeah :D Love you mestre :* and sorry for misunderstanding. Pawe?

I already tried to not set the source file until I want to call the fnDraw() function but it will still try to draw itself and because it has no source it throws a 404 error. Solved it, used an if statement in the "fnServerData": function (sSource, aoData, fnCallback) { ... }

thank you for the help,got it

make use of dynamically created tables with JSON source