X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR BOOTSTRAP XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO Sort Property


Recordset Object Reference 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"
%>

or

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

or

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


Recordset Object Reference Complete Recordset Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE

facebook