Search

However, after I empty and repopulate tbody, the sorting goes missing. Sounds like the append FAQ. In short, use the API to manipulate the table. Allan

the tbody are all sorted equally. There are no

render naturally and numeric sorting will work. This applies

oSettings.aoData are changed after sorting, but it is problem.

HI Does anyone have an answer to this question: put the sorting arrow right beside the column title? Thanks for any hint answer.

I found an alternative code : [code] for($i=0; $i<intval($GET['iSortingCols']); $i++) { if($_GET['bSortable'.intval($GET['iSortCol'.$i])] == true) { if($aColumns[intval($GET['iSortCol'.$i])] == 'date_reception') { if($typeDossier == 'M018') { $sOrder .= 'STR_TO_DATE(date_intervention,\'%d/%m/%Y\') '.$GET['sSortDir'.$i].', '; } else { $sOrder .= 'STR_TO_DATE(date_reception,\'%d/%m/%Y\') '.$GET['sSortDir'.$i].', '; } } else { $sOrder .= $aColumns[intval($GET['iSortCol'.$i])].' '.$GET['sSortDir'.$i].', '; } } } [/code] With STR_TO_DATE(date,'%d/%m/%Y) my sorting works well. I'm using the server side method.

said that, the html sorting type probably should cope

Here is your example http://datatables.net/release-datatables/examples/server_side/server_side.html. Okay? When the data arrives at the server, how do you know which button the user has clicked (sorting or paging)? Just know, without any action

Thanks for your reply. aaSortingFixed option helped me. I just used a invisible column and on this i did the sorting. and that fulfill my requirement of adding row on top the table.

notice there is a Sorting section within jquery.dataTables.css which