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

CFQUERY

CFQUERY passes SQL statements for any purpose to your data source. Not limited to queries.

Syntax

<CFQUERY NAME="query_name"
    DATASOURCE="ds_name"
    DBTYPE="type"
    DBSERVER="dbms"
    DBNAME="database name"
    USERNAME="username"
    PASSWORD="password"
    MAXROWS="number"
    BLOCKFACTOR="blocksize"
    TIMEOUT="milliseconds"
    CACHEDAFTER="date"
    CACHEDWITHIN="timespan"
    PROVIDER="COMProvider"
    PROVIDERDSN="datasource"
    DEBUG>


SQL statements

</CFQUERY>


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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