ADO Sort Property
 Complete Recordset Object Reference
The Sort property sets or returns a string value that specifies the field names in the Recordset
to sort on. Each field name must be separated by a comma. To choose the sort
order, you can specify ASC (ascending order), or DESC (descending order) after
the field name. Default is ASC.
Note: This property can only be used if the CursorLocation property is
set to adUseClient.
Tip: If you set this property to an empty string (rs.Sort="")
it will reset the records to their original order.
Syntax
Example
<%
rs.Sort="CompanyName,ContactName"
%>
or
<%
rs.Sort="CompanyName DESC,ContactName"
%>
or
<%
rs.Sort="CompanyName,ContactName,[Ship Address]"
%>
|
Complete Recordset Object Reference
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
