Sort - property of the AdoRecordset object
Description:
Returns or sets the field names in the AdoRecordset to sort on.
The property returns or sets a value of the
String type that specifies the field names in the
AdoRecordset object to sort on. Each field name must be separated by a comma. To select the sort order, you can specify
ASC (ascending order), or
DESC (descending order) after the field name.
The default value is
ASC.
Note:
Property access for read and write.
Example:
JavaScriptVBScriptSelect and copy to clipboard
oRs.Sort = "CompanyName DESC,ContactName";
oRs.Sort = "CompanyName DESC,ContactName"