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

Chapter 4. Interacting with Databases: Retrieving Data

Chapter 4. Interacting with Databases: Retrieving Data

One of ColdFusion's core strengths is its ability to interact with databases. For ColdFusion to work with a database, the database must be set up as a data source through the ColdFusion Administrator. Data sources can be set up through ODBC, OLE (Object Linking and Embedding) DB, or through native drivers that are provided with ColdFusion. After the data source is established, you use the <cfquery> tag to compose and send your commands to the database.

Database commands are written in the Structured Query Language (SQL). Different SQL commands are available for each of the different ways you might interact with the database. This chapter focuses on the use of the SQL SELECT statement, which you use to retrieve data stored in the database. You'll learn more details about the other kinds of SQL statements in Chapter 5, “Interacting with Databases: Inserting, Updating, and Deleting.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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