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

cfquery

cfquery

<cfquery name = "query_name" 
        dataSource = "ds_name" 
        username = "username" 
        password = "password" 
        maxRows = "number" 
        blockFactor = "blocksize" 
        timeout = "seconds" 
        cachedAfter = "date" 
        cachedWithin = "timespan" 
        debug = "Yes" or "No"  or debug> 

SQL statement(s) 

</cfquery> 

Description

Use this tag to write structured query language (SQL) queries that are passed on to your database through the datasource name. SQL statements within this tag are executed just as they are written and can be used to select, insert, update, or delete data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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