Sorting on hidden columns and passing direction
Sorting on hidden columns and passing direction

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"
This discussion has been closed.
Answers
A forum search would find the answer.
http://legacy.datatables.net/usage/columns#iDataSort