fnSortListener usage

Daveomania

Hi there,

I am having problems trying to get my data to sort properly. For example, if I have a table with 10 rows and each row is 1-10:

1
2
3
4
5
6
7
8
9
10

When I hit the sort for the top of that row, I end up with:

1
10
2
3
4
5
6
7
8
9

When I load the table I use [code]fnSort([[0, 'asc']]);[/code] and that works for the initial rendering.

So what I am wondering is can I use the listener and attach it to only that column header? Using iDataSort gives me the same unwanted results.. so I need a way to get around this.

Thanks for any help!!!

Dave

allan

The sorting order you indicate suggests that DataTables has picked they type up as 'string' rather than 'numeric'. I would guess that this is because you have white space around the numbers in the table (or some other non-numeric character). You could try 1.7 beta 5 which will automatically deal with this, or modify your HTML to not have any white space.

Regards,
Allan

Daveomania

Hi Allan and thanks for the response,

I will try removing the whitespace and if that fails I will attempt using 1.7 beta 5. I will post back my outcome.

:D

Daveomania

Well I trimmed the values coming out of the database and then there you have it. It is sorting properly.

Thank you very much Allan!

Dave

allan

Good to hear this worked :-). This is why this feature is included in the 1.7 series :-)

Regards,
Allan