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

Part V: Appendixes > <CFQUERY>, </CFQUERY>

<CFQUERY>, </CFQUERY>

Description: <CFQUERY> submits SQL statements to an ODBC driver. SQL statements are not limited to SELECT statements, but can also be INSERT, UPDATE, and DELETE statements, as well as calls to stored procedures. <CFQUERY> returns results in a named set if you specify a query name in the NAME attribute. The <CFQUERY> attributes set up the query, and any text between the <CFQUERY> and </CFQUERY> tags becomes the SQL statement that is sent to the ODBC driver. ColdFusion conditional code may be used between the <CFQUERY> and </CFQUERY> tags, allowing you to create dynamic SQL statements.

Syntax:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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