Search

Hi, I've worked this out now. In my server side handling page I had a few lines of whitespace at the top. IE 8 and firefox handled this, but IE7 looses the plot if there is white space before the JSON data. Supressing the whitespace fixed it.

thank you it helped me a lot

Sorry, weird caracters in string caused the problem.

This looks like a duplicate of http://datatables.net/forums/comments.php?DiscussionID=83&page=1#Item_13 . An answer to the issue is provided in that thread.

Sorry saw someone mention using live closed window though. Solution example as follows [code] $ ('#eData tr').live ('click', function() { if ( $(this).hasClass('row_selected') ) $(this).removeClass('row_selected'); else $(this).addClass('row_selected'); [/code]

Hi Shaun, You can add as many columns as you want coming back from the server-side - they don't need to 1:1 map to the database. Here is an example which adds a link tag: http://datatables.net/forums/comments.php?DiscussionID=1388 Allan

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! :)