Basic SQL for ADO Recordsets

Abstract

Much of the communication between ASP-ADO and the database is conducted by the Structured Query Language (SQL). This chapter covers the fundamentals of reading data through the use of SQL statements. (SQL for changing and adding data is covered in Chapter 10.) In addition to the syntax of SQL statements, this chapter discusses specifically how to build those statements using ASP. The chapter ends by addressing the complexities added by using data gathered from forms or server functions.

Mateo Ricci, the 16^th century Jesuit Missionary, commented that the Classical Chinese Language was tremendously difficult to learn, but that the years spent in its mastery were of benefit to society in that they diminished the “youthful licentiousness” to which young men would otherwise be inclined.