Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

Chapter 41. More About SQL and Queries

<feature><title>In This Chapter</title>

• Advanced SQL Topics E3

• Additional <cfquery> Topics E40

• Using Database Transactions E67

</feature>

Advanced SQL Topics

You have already learned quite a bit about SQL in this book. In Chapter 6, “Introducing SQL,” in Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started, you learned how to retrieve records using SELECT, WHERE, and ORDER BY. In Chapter 7, “SQL Data Manipulation,” also in Vol. 1, Getting Started, you learned how to change the data in your database with INSERT, UPDATE, and DELETE and how to use the AS keyword to create aliases. You have also seen how the <cfquery> tag lets you create SQL statements dynamically, based on form parameters ...