Sorting on hidden columns and passing direction

psib3r

Hi, can't seem to work this out, I have a table [Surname], [Firstname], [Surname Firstname], [DOB]

Surname and Firstname are hidden, what I want it to do is sort on Surname (either asc or desc as normal) then firstname (always asc) when i click on the [Surname Firstname] column. Is this possible?

A bit like if it was SQL it would be like "order by Surname @escdesc, Firstname"

tangerine

A forum search would find the answer.

http://legacy.datatables.net/usage/columns#iDataSort