Search

Hi orange, Awesome - thanks very much :-) Allan

i managed to fix myself by calling $.getJSON and modifying the json array to fit as a source for "aaData". for reference to anybody else here is my solution: [code] $.getJSON( '/myjson_source.php', null, function(json){ oTable = $j('.sortable').dataTable({ "aaData" : json, "aaSorting" : [[ 1, "desc" ],[ 0, "asc" ]], "sDom" : '<"top"fl>rt<"bottom"pi<"clear">', 'aoColumns' : [{ "sWidth": "400px", "sClass": "m-row2 m-row2-fade" }, { "asSorting":["desc","asc"], "sClass": "m-row1" }, { "asSorting":["desc","asc"], "sClass": "m-row1" }, { "asSorting":["desc","asc"], "sClass": "m-row1" }, { "asSorting":["desc","asc"], "sClass": "m-row1" }, { "asSorting":["desc","asc"], "sClass": "m-row1" }, { "asSorting":["desc","asc"], "sClass": "m-row3" }, { "asSorting":["desc","asc"], "sClass": "m-row3" }, { "asSorting":["desc","asc"], "sClass": "m-row4" }, { "asSorting":["desc","asc"], "sClass": "m-row4" }, { "asSorting":["desc","asc"], "sClass": "net m-row_zero" }, { "asSorting":["desc","asc"], "sClass": "net m-row_zero" }] }); // add extra jquery here to change classes }); [/code]

Hi, I resolved the problem, it was my fault. thank to your advise to use firebug, it helps me showing a php warning inside the output source. Leo

Thanks Allan, these are all good suggestions. I had already noted the performance bump from disabling bSortClasses in other tables, and I have even disabled sorting entirely on this table to get as much speed as possible. (I still use DataTables for its filtering, pagination and row manipulation features.) I did some more investigation and discovered that it is not the rendering which takes the majority of the time, but the JSON download and processing (the JSON data is ~750KB and rising). So, in order to display a proper progress bar, I'd need to get download processing feedback from the getJSON procedure, which just isn't possible AFAIK... Just as I type this, it occurs to me that I could manually perform the getJSON request outside of the DataTables init function, but grab it in four or five smaller chunks. This way I could give a progress update on complete of each JSON chunk. Although there would be more XHR loads, there would be more feedback to the user at an early stage of the load. Once I've got the JSON data loaded into a variable, it seems it would be a simple matter of using fnAddData() each time... Will feed back any further developments! :)

Hi mathie, Two options spring to mind, Just do the initialisation for each DataTable when the tab becomes active. Initialise the all together with empty data, as you suggest, and then you fnReloadAjax() to populate them as required using the tab's events handlers. Regards, Allan

Thanks Allan, It does seem to be security, but as this is only running locally in a static format, I have seperated Firefox and Others, with firefox using js_array and all others (tested and working) using json. I find JSON seems to perform better than js_array on IE..

afaik all rows all numbered from 0-length of rows, so just create array of indexes and put into hidden field Another approach is to create a hidden column which takes 1 or 0 depending if checked or just fnUpdate all rows and put the checked marker in that column.

Thanks, I will try it. I'm very impressed with your quick answer on all post!

Well thank you for dataTables....its amazing!

for helping to debug Ajax/Json errors: http://www.jsonlint.com/ Allan