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

objRecordset.Sort

Example

<%
rs.Sort="CompanyName,ContactName"
%>

<%
rs.Sort="CompanyName DESC,ContactName"
%>

<%
rs.Sort="CompanyName,ContactName,[Ship Address]"
%>

Complete Recordset Object Reference