Thread: sorting
View Single Post
  #1 (permalink)  
Old June 20th, 2003, 12:08 PM
Greg Griffiths Greg Griffiths is offline
Friend of Wrox
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default sorting

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.
All the best

Greg Griffiths
Web & Livelink Developer