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

Chapter 5.  Accessing Databases Using... >  Accessing Databases from a ColdF...

Accessing Databases from a ColdFusion MX Application

You can use the data source by applying the <CFQUERY> tag in conjunction with SQL statements. Perform the following tasks to retrieve data from a database:

  1. Use the <CFQUERY> tag to connect to a database.

  2. Include SQL commands inside the <CFQUERY> block to specify the operations you want to perform on the data. The retrieved data, called the result set, is stored on that page as a query object.

  3. Finally, reference the query object and use its data values in a tag that displays data, such as <CFOUTPUT>, <CFGRID>, or <CFGRAPH>.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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