ADO TutorialLesson 65Free preview

ADO Query

This lesson is part of ASP · All levels

Summary

The SELECT query with ADO is run through conn.Execute and the result is stored in the Recordset object. The WHERE clause filters the relevant row, ORDER BY sets the order, and COUNT(*) counts the total row without displaying the contents. For dynamic user data, use parameters to keep queries secure and efficient.

Key points

Conn.Execute("SELECT...") returns the Recordset containing the query results.
WHERE filters the line, ORDER BY sorts, and COUNT(*) counts the line.
Parametric queries are safer than combining SQL strings.
Close the recordset after you're done so the connection resource doesn't get stuck.

Full lesson

Code examples and quizzes

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