Tutorials References Exercises Sign Up Menu
Create Website Get Certified Pro

ADO Sort

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

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):



set conn=Server.CreateObject("ADODB.Connection")
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%">
  <%for each x in rs.Fields
    response.write("<th>" & x.name & "</th>")
  <%do until rs.EOF%>
    <%for each x in rs.Fields%>

Show example »

More Examples

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.