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 |
The Altova MissionKit is a suite of intelligent XML tools, including:
XMLSpy® – industry-leading XML editor
- Support for all XML-based technologies
- Graphical editing views, powerful debuggers, code generation, & more
MapForce® – graphical data mapping tool
- Drag-and-drop data conversion with code generation
- Support for XML, DBs, EDI, Excel® 2007, text, Web services
StyleVision® – visual stylesheet designer
- Drag-and-drop stylesheet design for XML & databases
- Output to HTML, PDF, RTF, Word 2007, & more
And more…
Try before you buy with a free fully functional 30-day trial
Download today
 |
|
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 JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|
HOME
Printer friendly page
