Search

Not come across this one before - can you post a link to an example showing this issue please? Allan

I once started down the road of attempting to send data back to the server to create an Excel spreadsheet, but then the requirements of the project changed so I didn't actually get very far with it. I was using fnGetFileredData and then looping through the results to build up the data in JSON structure. I'm pretty awful at JavaScript myself so I'd like to see some other solutions, but here is a function from my notes that was working as far as it goes... [code] < script type="text/javascript"> $(document).ready( function() { $('#classSummary').click( function () { var myTable=new Array(); var myJSON; myJSON = '{"bindings": ['; var aNodes = oTable.fnGetFilteredData(); for ( var i=0, iLen=aNodes.length ; i<iLen; i++) { myJSON = myJSON + '{"Name":"' + aNodes[i][0] + '",'; myJSON = myJSON + '"FullName":"' + aNodes[i][1] + '",'; myJSON = myJSON + '"AskAmount":"' + aNodes[i][2] + '",'; }; myJSON = myJSON + "]};"; }); }); [/code] On the server, I was going to use perl modules to parse the JSON and create the Excel file. Probably these: http://search.cpan.org/~makamaka/JSON-2.22/lib/JSON.pm http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/

Thanks Allan, will be checking it out :)

Thanks very much for considering this.

ok solved is only put in place the tabletools.js tabletools.min.js

Please see the FAQ about events: http://datatables.net/faqs ( Q. My events don't work on the second page ). This apples here also. Allan

Hi conryf, Interesting! Are you able to post a link to an example of this happening (or send the link to my directly, if you don't want to make it public, at http://datatables.net/contact )? It would be great to track this one down! I would guess that one of the elements in your array is an integer, but DataTables is creating it as a string... In fact 'i' as you point out from the casting. Definitely a bug in DataTables. I'm working on a new beta of 1.7 just now - hope to get this one fixed for that release. Regards, Allan

Interesting change - probably not one I'l include in the main distribution for now (unless there is a big demand for it) - but good to see some hacking going on with the source :-). Thanks for posting your changes! Another way to go without altering the source would be to manipulate the DOM after DataTables initialisation. Regards, Allan

Hi Patrick, Do you mean 1.6.2? I've just tried it with 1.7 beta 2 and it looks okay there. There shouldn't be any differences in this area from 1.6.2. Any JS errors or anything? Allan

the datatables in the "sc_list1.html" ,print button also in the "sc_list1.html", I want every node are hidden but the datatables when I press the print button.