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 |
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a free 30-day trial today!
Click to see a demo!
Learn what’s new in v2008
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|