O'Reilly logo

Inside ColdFusion™ MX by Robi Sen, Neil Ross, John Cummings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required