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

Summary

A data source is needed in order for ColdFusion to communicate with a database. The data source is effectively a driver that acts as a translator for communicating SQL statements to the database back end. <cfquery> is used to prepare the SQL statements and send them through to the data source with the appropriate connection settings. <cfquery> can pass any SQL statement that the data source can handle.

A record set passed back to <cfquery> is converted into a query object. The query object can be looped over for each individual record, and the values of the various columns can be output by using <cfoutput>. <cfoutput> has a group function that provides additional output options for record sets ordered by a particular column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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