Search

this problem occurs only when i am using "DataTables complex header example (row and colspans)".

http://datatables.net/forums/discussion/5839/scroll-with-fixedcolumn/p1?post#Form_Body

Thank you :-). Great to hear that did the job for you! Regards, Allan

force that column to sort as string. it should work. http://www.datatables.net/usage/columns#sType it was probably auto-detecting 'html' type, which strips/ignores the html [code] "aoColumnDefs": [ { "sType": "string", "aTargets": [ 0 ] } ] [/code]

I have the same problem with you, hope somebody to help us!

Do you mean you want to access the hidden TD elements? If so, then this plug-in is what you are looking for: http://datatables.net/plug-ins/api#fnGetTds :-) Allan

Ok I think I finally got it. It seems I had to change [code] var nRemove = $(row).next()[0]; nRemove.parentNode.removeChild(nRemove); [/code] to [code] table.fnClose(row); [/code]

I did further checking and I can see the missing col in the Chrome inspector, it's just not being displayed because there is not enough space. When the data has been fetched, DataTables adds a X-scrollbar and everything is fine.

Hi adisa, did you try like this: [code] function fnShowHide( iCol ) { /* Get the DataTables object again - this is not a recreation, just a get of the object */ var oTable = $('#example').dataTable(); var bVis = oTable.fnSettings().aoColumns[iCol].bVisible; oTable.fnSetColumnVis(iCol, bVis ? false : true); oTable.fnAdjustColumnSizing(); } [/code]

instead of echo or print_r, include a copy of $sQuery in the JSON returned so you can inspect it [code] // make a copy of your original $sQuery , call it $sReturnQuery $output = array( "sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array(), "sQuery" => $sReturnQuery // add query to return JSON so we can inspect it ); [/code]