Search

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

szymon, It has been fixed as of the 1.0.6 nightly of ColVis, more info here: http://www.datatables.net/forums/discussion/comment/22562#Comment_22562 Cheers, CHgsd

That's awesome - thanks! I'll have a closer look at the pull request in the next few days. Regards, Allan

numberone, I'm using server side processing with PHP 4.x so not JSON version. I have SQL working for non-DataTables but can't figure out how to make my SQL work with DataTables and hoping your solution can work. I have one table (po_spots) that can have multiple date ranges (launchdate) grouped with a primary key value (ponumber). I need to find the earliest date within that group and eventually assign as 'mindates.' Then join with table po_gen_info. Like I said, my SQL statement is working but not with Datatable. Working SQL is: [code] SELECT po_gen_info.client,po_gen_info.promotitle,po_gen_info.projectlead,po_gen_info.station_kamx,po_gen_info.station_kkmj,po_gen_info.station_kjce,mindates.* FROM ( SELECT ponumber , MIN(launchdate) AS earliestdate FROM po_spots WHERE produced != 'Yes' GROUP BY ponumber ) AS mindates INNER JOIN po_spots ON po_spots.ponumber = mindates.ponumber AND po_spots.launchdate = mindates.earliestdate INNER JOIN po_gen_info ON po_spots.ponumber = po_gen_info.ponumber GROUP BY ponumber ORDER BY mindates.earliestdate [/code] Can your approach work for me and if so can you please give me examples I can try? Thanks,

Thanks, allan. "bVisible": false did the trick.

i fixed the problem with multi sorting.. old one : [code] for($i = 0; $i < intval($this->ci->input->post('iSortingCols')); $i++) $sOrder .= $columns[intval($this->ci->input->post('iSortCol_' . $i))] . ' ' . $this->ci->input->post('sSortDir_' . $i) . ', '; [/code] fixed one: [code] $sColumnsArray = explode(',', $this->ci->input->post('sColumns')); for($i = 0; $i < intval($this->ci->input->post('iSortingCols')); $i++) $sOrder .= $sColumnsArray[intval($this->ci->input->post('iSortCol_' . $i ))] . ' ' . $this->ci->input->post("sSortDir_" . $i) . ', '; [/code]