"aaSorting" is not working properly in IE8

santoshhk1

Hi,
Plz help me.
i have used is like
"aaSorting": [[2, 'asc']]
but is it showing some records not in sorted order(IE8)
It works fine in Firefox.

llevering

Can you post a bit of your code? Or a link to the page with the problem?

santoshhk1

Here i am pasting the code
//-------------------apply DataTable plunin-------------
dm.page.land.vCampTbl = $('#tblCampaign').dataTable({
"iDisplayLength": 15,
"bProcessing": false,
"bFilter": false,
"oStdClasses": false,
"bLengthChange": false,
"dataTables_info": false,
"bRetrieve": true,
"bDestory": true,
"sInfo": false,
"aaSorting": [[2, 'asc']], // Default sorting parameter
"aoColumns": [
{ "bSortable": false },
{ "bSortable": false },
null,
{ sType: 'html-numeric' }, //Messages //To sort by numeric data //TODO:Sorting with , and % symbols..
{sType: 'html-numeric' }, //Total send
{sType: 'html-numeric' }, //Delivary
{sType: 'html-numeric' }, //Open
{sType: 'html-numeric' }, //Click
null, //Campaign owner
null, //Creation date
null, //Expiry date
null, //status
{sType: 'html-numeric' },
{sType: 'html-numeric' },
{sType: 'html-numeric'}
],
"sPaginationType": "full_numbers"

});

llevering

I tried to build a minimal example based on your code, for me it is functioning well, but maybe there is some special data in it. The example you can find at: http://atest.adresbak.nl/testDt.html

santoshhk1

Thank you for your kind efforts.
yes some special char data may be in database table.i don't have any option to change data in database.
i think there may be some spaces chars before values in that column.
but i used $trim() also,but it is not working.
please help

llevering

Well maybe you will have to find out which characters are causing the problem and fixing them with a regular expression or something. Sounds like there won't be an easy solution.

allan

You could try using this sorting plug-in which will remove non-numeric information and then sort by whatever is left: http://datatables.net/plug-ins/sorting#formatted_numbers

Allan