Chapter 24. Advanced Database Interaction

In previous chapters, we reviewed some of the basic concepts relating to relational databases as well as the fundamental ways ColdFusion can interact with a database. Our interactions with the database have been based on static structured query language (SQL) statements. Take a look at the code in Listing 24.1. This is a simple select statement that returns all records from the database table named State, where the state name begins with the letter C. The recordset returned would look something like Figure 24.1.

Recordset returned by the simple select statement.

Figure 24.1. Recordset returned by the simple select statement.

Example 24.1. A Simple Static Select ...

Get Inside ColdFusion™ MX now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.