ADO Sort

From http://www.w3schools.com (Copyright Refsnes Data)

# ADO Sort

We may use SQL to specify how to sort the data in the record set.

## Examples

Sort the records on a specified fieldname ascending
How to sort the data on a specified fieldname.

Sort the records on a specified fieldname descending
How to sort the data on a specified fieldname.

Let the user choose what column to sort on
Let the user choose what column to sort on.

## Sort the Data

We want to display the "Companyname" and "Contactname" fields from the "Customers" table, ordered by "Companyname" (remember to save the file with an .asp extension):

    <html>
    <body>

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/northwind.mdb"

    set rs = Server.CreateObject("ADODB.recordset")
    sql="SELECT Companyname, Contactname FROM
    Customers ORDER BY CompanyName"
    rs.Open sql, conn
    %>

    <table border="1" width="100%">
      <tr>
      <%for each x in rs.Fields
        response.write("<th>" & x.name & "</th>")
      next%>
      </tr>
      <%do until rs.EOF%>
        <tr>
        <%for each x in rs.Fields%>
          <td><%Response.Write(x.value)%></td>
        <%next
        rs.MoveNext%>
        </tr>
      <%loop
      rs.close
      conn.close%>
    </table>

    </body>
    </html>

Here is the result:

Companyname | Contactname
--- | ---
Alfreds Futterkiste | Maria Anders
Berglunds snabbköp | Christina Berglund
Centro comercial Moctezuma | Francisco Chang
Ernst Handel | Roland Mendel
FISSA Fabrica Inter. Salchichas S.A. | Diego Roel
Galería del gastrónomo | Eduardo Saavedra
Island Trading | Helen Bennett
Königlich Essen | Philip Cramer
Laughing Bacchus Wine Cellars | Yoshi Tannamuri
Magazzini Alimentari Riuniti | Giovanni Rovelli
North/South | Simon Crowther
Paris spécialités | Marie Bertrand
Rattlesnake Canyon Grocery | Paula Wilson
Simons bistro | Jytte Petersen
The Big Cheese | Liz Nixon
Vaffeljernet | Palle Ibsen
Wolski Zajazd | Zbyszek Piestrzeniewicz

From http://www.w3schools.com (Copyright Refsnes Data)