Search

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]

How would I use the HTML for sorting (for example by using a title in an empty span) but exclude the HTML from the search? Campbell

You would indeed :-). Or fnSettings().aoColumns.length if you have the instance available. Allan

Thanks for answering. Lets focus on the URI, used to pass a query (basic HTTP-GET) RFC 2396 says it does not specified the way to use an URI, it specify the syntax and notation. The way to use it depends on the system that parse it. The chars "[" and "]" are no preserved inside the query param name and value - so they can be used. The data passed in the body using HTTP-POST uses the same notation. So there should be no problem on any smart server platform. But your still right, there is a problem - the programming language used serverside. What PHP does as programm called by server: it creates a session for the request and initialize some data passed from the server. This includes vars such as _GET and _POST. You can also access the raw URI, request body and URI query which where passed to php. As i know in PHP 5.3 you can even disable this initialization so _POST and _GET is always empty and you can work using the RAW data. Maybe some other programming language/libraries do not include such an initialization, but you still should have the RAW data, which you can parse a similar way you do it now. I cant imagine a reason why a server should not accept this URI query or DATA inside HTTP body. But maybe i learn something new today :) If im right, this would be a progressive enhancement. Those who cannot use it wouldnt be damaged, those who can could process it easier. Noticaeble problem is the lack downward compatibility changing such things for already written code :( I can imagine there are alot of datatables users using php. PHP is very common in WEB :)

Hi guys, Did you succeed to resolve this problem, cause I'm in the same situation. Thanks. Micka