Coldfusion Column Sorting
Posted on 2001-09-07
I want to know how to sort the columns of a query. I know how to do it via the SQL statement. What I need is for a user to be able to pull up the webpage with query and click on the column headings of the table to sort it by that column(asc AND desc would be great...). For example... Lets say I have a table called "music", and I have fields: ID, Artist, Title, Description, and etc. I want the user to be able to click on ID to sort the table by ID and if they click on Artist, sort by artist, and etc. If there is anyone who can help me on this, it would be greatly appreciated.