Sorting info in columns

Results 1 to 2 of 2

Thread: Sorting info in columns

  1. #1
    Join Date
    Dec 1969

    Default Sorting info in columns

    Is there a way that users can click on a column in a table to change the sort order from ascending to descending (or vice versa)? The data in the table is extracted from a database.<BR><BR>Thanks in advance

  2. #2
    Paul Merton Guest

    Default RE: Sorting info in columns

    This sort of thing may be possible in IE5 only if you are intending to do it on the client&#039s side.<BR><BR>If, however, you are going to do it with ASP, then it&#039s quite easy. Simply have a button (or whatever) at the top of each column that goes to the page and runs the same SQL query again, but with "ORDER BY name_of_field" at the end of it. When you go through the recordset now, it will be ordered by that field name.<BR><BR>Hope that helps,<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts