16
CFML Quick Reference
or:
debug
>
SQL statement(s)
</cfquery>
cfqueryparam
<cfquery
name = "query_name"
dataSource = "ds_name"
...other attributes...
SQL STATEMENT column_name =
<cfqueryparam value = "parameter value"
CFSQLType = "parameter type"
maxLength = "maximum parameter length"
scale = "number of decimal places"
null = "Yes" or "No"
list = "Yes" or "No"
separator = "separator character">
AND/OR ...additional criteria of the WHERE clause...
</cfquery>
cfregistry
<cfregistry
action = "getAll"
branch = "branch"
type = "data type"
name = "query name"
sort = "criteria">
<cfregistry
action = "get"
branch = "branch"
entry = "key or value"
variable = "variable"
type = "data type">
<cfregistry
action = "set"
branch = "branch"
entry = "key or value"
type = "value type"
value = "data">
<cfregistry
action = "delete"
branch = "branch"
entry = "keyorvalue">
cfreport
<cfreport
report = "report_path"
dataSource = "ds_name"
type = "type"
timeout = "number of seconds"
orderBy = "result_order"
username = "username"
password = "password"
formula = "formula">
</cfreport>
cfrethrow
<cfrethrow>
cfreturn
<cfreturn
expr>
cfsavecontent
<cfsavecontent
variable = "variable name">
the content
</cfsavecontent>
cfschedule
<cfschedule
action = "update"
task = "taskname"
operation = "HTTPRequest"
file = "filename"
path = "path_to_file"
startDate = "date"
startTime = "time"
url = "URL"
port = "port_number"
publish = "Yes" or "No"
endDate = "date"
endTime = "time"
