Sorting on mulitple colums
I have a several columns of data coming back from a query that I present to the user, I would like to be able to allow the user to sort this as they see fit.
Initially I've used an array and the SORT function, but the requiements are now to allow sorting of the following nature :
sort by col1 ascending then col2 descending
This is a lot more complex than just a simple SORT call. Some people have suggesting using XML for the data and the sorting, but I've not used it heavily, others have suggested building a DB call each time, but I'd prefer to do it client side.
I'd appreciate any thoughts or comments from the group.