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

Chapter 7. Using Databases > Querying Queries

Querying Queries

The result of using <cfquery> is effectively a record set sitting in memory on the application server. This query might be available only for the current page execution, or it might be placed into a more permanent memory scope, such as the application, session, or server scope. It could even be a temporarily cached query, by way of the cachedwithin and cachedafter attributes. Although a query's information might be readily available to the application server, developers typically go back to the database if they need to manipulate the query data in some way (for example, to re-sort or filter the record set).

→ Shared variable scopes are covered in Chapter 10, “Application and Server Variables,” and Chapter 11, “Session State Management.”



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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