Sorting columns

Results 1 to 3 of 3

Thread: Sorting columns

  1. #1
    Join Date
    Dec 1969

    Default Sorting columns

    I have a recordset which has nearly hundreds of records.<BR>I want to sort the records on ascending or descending order in the display page(The user should be able to sort this by just clicking the column heading which may have appropriate buttons or arrows one pointing up for sorting the results ascending and other pointing down for sorting the results in descending order)

  2. #2
    Join Date
    Dec 1969

    Default RE: Sorting columns

    use the ORDER BY clause in your SQL<BR><BR>the column headers should pass the name of the column to be sorted<BR><BR>If Request.QueryString("sort") Then<BR>strSQL = strSQL & " ORDER BY " & Request.QueryString("sort")<BR>End If<BR><BR>basically<BR><BR><BR><BR>j<BR>

  3. #3
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, General

    Gives a complete example of doing it on the server with a link to a way that does it in the browser.<BR><BR>The link to the ASPFAQs is at the top right corner of this very page.<BR><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