Sort recordset user end

[robert475]

Hi

I have a recordset that i would like the enduser using the program can order the results displayed on screen themselves i.e. in excel you can order the data by asc or desc by clicking on the relevant column.

I know in my query that is fetching the data, i can use the order by clause but i would like the user to be able to do it themselves. I have 4 columns of data that would need this applying to.

I am aware i can use a requestQuerystring method but is there another/better way of executing this?


Thanks

[Old Pedant]

http://www.clearviewdesign.com/clearviewdesign/newbie/

I have two demos there: One uses ASP code to re-sort the table, the other uses JavaScript in the browser. Those demos are ancient, so apologies that the JS code is not up to modern standards.

You *can* also do this without resorting to a frameset, et al., just doing all the codign in a single window using JS and DOM methods.