ADO TutorialLesson 66Free preview

ADO Sort

This lesson is part of ASP · All levels

Summary

Data sequencing is performed by an ORDER BY clause that can raise (ASC) or lower (DESC) the order based on one or more columns. For record sets that support indexed cursors, re-ordering can also be done through the Sort property without running new queries. The correct sequencing makes the data easier for the user to read.

Key points

The ORDER BY column displays the results by default from small to large (ASC).
DESC is used for descending sequences such as Z to A.
Some columns of the sequence can be combined with commas.
Recordset with appropriate cursors can be rearranged via the rs.Sort property.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.