Sort - property of the AdoRecordset object
Description:
The property 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 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"