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

Chapter 24. Advanced Database Interaction > Query of Queries (CFSQL)

Query of Queries (CFSQL)

One of the new features introduced with the release of ColdFusion 5 was the query of queries. The query of queries (CFSQL) is actually an extension of the CFQUERY tag that we have already covered. With a basic CFSQL, you begin with a CFQUERY tag just as we have done in previous examples. You then write a second CFQUERY tag with two modifications—you do not use the datasource attribute and you set the DBTYPE attribute to query.

There are a number of advantages offered by the use of a CFSQL. The first potential use is to reduce the interaction with the database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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