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

Name

cfquery

Synopsis

<cfquery>
  [<cfqueryparam>]
SQL statements
</cfquery>

Performs SQL operations against a data source or existing query object. In ColdFusion MX, SQL reserved words can no longer be used as column or query names. When building dynamic queries from form or URL parameters, Macromedia recommends always binding the parameters with cfqueryparam tags.

Attributes

name=" query_name "

Name to assign to the query. Valid query names must begin with a letter, underscore, or Unicode currency symbol ($) and can contain only letters, numbers, underscores, and Unicode currency symbols. Required when passing an SQL select statement; optional for all other SQL operations. Although the name attribute is required only for SQL select statements, you may wish to use it in all your queries. It makes debugging easier, especially for templates that contain multiple queries, because it allows you to identify each query by name in the debugging output.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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