• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Advanced Database Interaction

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.

Figure 24.1. Recordset returned by the simple select statement.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint