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

11. Advanced Database Techniques > 11.5. Query of Queries

Query of Queries

Now that you have an understanding of advanced SQL, it’s time to introduce a new concept known as “query of queries” or CFSQL (ColdFusion SQL). Introduced in ColdFusion 5.0 and greatly enhanced in MX, query of queries allows you to use the cfquery tag to query an already existing query object using a subset of ANSI SQL 92. This feature makes it easy to program functionality previously difficult or impossible to implement in ColdFusion. Some potential uses for query of queries include:

  • Manipulate query objects (sort, summarize, group, etc.) returned by other ColdFusion tags such as cfhttp, cfftp, cfldap, cfpop, cfsearch, or cfstoredproc as well as the various query functions


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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