[Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.]
Indicates how to sort the results set of a query, by listing column names and sorting order.
This property is read/write.
HRESULT put_SortBy( [in] BSTR val ); HRESULT get_SortBy( [out, retval] BSTR *val );
One or more existing result set column names, separated by commas. Each column name can be followed by an optional sort order identifier: [a] for ascending and [d] for descending order. The column names must already exist in the ADO recordset object.
This property sorts results in ascending order ( [a] ) by default. The query string variables associated with this property are so (sort order) and sd (sort descending).
|Minimum supported client
||Windows 2000 Professional [desktop apps only]
|Minimum supported server
||Windows 2000 Server [desktop apps only]
|End of client support
|End of server support
||Windows Server 2008 R2