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.
Figure 24.1. Recordset returned by the simple
Example 24.1. A Simple Static Select ...