MACROMEDIA COLDFUSION MX 61-CFML User manual

CFML Quick Reference

Trademarks
Afterburner, AppletAce, Attain, Attain Enterprise Learning System,
Attain Essentials, Attain Objects for Dreamweaver, Authorware,
Authorware Attain, Authorware Interactive Studio, Authorware Star,
Authorware Synergy, Backstage, Backstage Designer, Backstage Desktop
Studio, Backstage Enterprise Studio, Backstage Internet Studio,
ColdFusion, Design in Motion, Director, Director Multimedia Studio,
Doc Around the Clock, Dreamweaver, Dreamweaver Attain, Drumbeat,
Drumbeat 2000, Extreme 3D, Fireworks, Flash, Fontographer,
FreeHand, FreeHand Graphics Studio, Generator, Generator Developer's
Studio, Generator Dynamic Graphics Server, JRun, Knowledge Objects,
Knowledge Stream, Knowledge Track, Lingo, Live Effects, Macromedia,
Macromedia M Logo & Design, Macromedia Flash, Macromedia Xres,
Macromind, Macromind Action, MAGIC, Mediamaker, Object
Authoring, Power Applets, Priority Access, Roundtrip HTML, Scriptlets,
SoundEdit, ShockRave, Shockmachine, Shockwave, Shockwave Remote,
Shockwave Internet Studio, Showcase, Tools to Power Your Ideas,
Universal Media, Virtuoso, Web Design 101, Whirlwind and Xtra are
trademarks of Macromedia, Inc. and may be registered in the United
States or in other jurisdictions including internationally. Other product
names, logos, designs, titles, words or phrases mentioned within this
publication may be trademarks, servicemarks, or tradenames of
Macromedia, Inc. or other entities and may be registered in certain
jurisdictions including internationally.
This product includes code licensed from RSA Data Security.
This guide contains links to third-party websites that are not under the
control of Macromedia, and Macromedia is not responsible for the
content on any linked site. If you access a third-party website mentioned
in this guide, then you do so at your own risk. Macromedia provides
these links only as a convenience, and the inclusion of the link does not
imply that Macromedia endorses or accepts any responsibility for the
content on those third-party sites.
Apple Disclaimer
APPLE COMPUTER, INC. MAKES NO WARRANTIES, EITHER EXPRESS
OR IMPLIED, REGARDING THE ENCLOSED COMPUTER SOFTWARE
PACKAGE, ITS MERCHANTABILITY OR ITS FITNESS FOR ANY
PARTICULAR PURPOSE. THE EXCLUSION OF IMPLIED WARRANTIES
IS NOT PERMITTED BY SOME STATES. THE ABOVE EXCLUSION MAY
NOT APPLY TO YOU. THIS WARRANTY PROVIDES YOU WITH
SPECIFIC LEGAL RIGHTS. THERE MAY BE OTHER RIGHTS THAT YOU
MAY HAVE WHICH VARY FROM STATE TO STATE.
Copyright © 1999–2003 Macromedia, Inc. All rights reserved. This
manual may not be copied, photocopied, reproduced, translated, or
converted to any electronic or machine-readable form in whole or in part
without prior written approval of Macromedia, Inc.
Part number: ZCF61M400
Project Management: Randy Nielsen
Editing: Linda Adler
First Edition: May 2002
Second Edition: August 2003
Macromedia, Inc.
600 Townsend St.
San Francisco, CA 94103

CFML Quick Reference 3
CONTENTS
CFML tags . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
CFML functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Array functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Authentication functions . . . . . . . . . . . . . . . . . . . . . . . . . 20
Conversion functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Date and time functions . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Decision functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Display and formatting functions . . . . . . . . . . . . . . . . . . . 22
Dynamic evaluation functions . . . . . . . . . . . . . . . . . . . . . 22
Extensibility functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Full-text search functions . . . . . . . . . . . . . . . . . . . . . . . . . 23
International functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
List functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Mathematical functions . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Other functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Query functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
String functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Structure functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
System functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
XML functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
ColdFusion variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Variable scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Caller scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Client variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Server variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Application and session variables . . . . . . . . . . . . . . . . . . . 28
Custom tag variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Request variable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Form variable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
ColdFusion tag-specific variables . . . . . . . . . . . . . . . . . . . . 29
ColdFusion query variables . . . . . . . . . . . . . . . . . . . . . . . . 30
CFCATCH variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
CFDIRECTORY variables . . . . . . . . . . . . . . . . . . . . . . . . 30
CFERROR variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
CFFILE ACTION=Upload variables . . . . . . . . . . . . . . . . 31
CFFTP error variables . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
CFFTP ReturnValue variable . . . . . . . . . . . . . . . . . . . . . . 31
CFFTP query object columns . . . . . . . . . . . . . . . . . . . . . 31
CFHTTP variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
CFLDAP variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
CFPOP variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
CFQUERY and CFSTOREDPROC variables . . . . . . . . . 32
CFREGISTRY variables . . . . . . . . . . . . . . . . . . . . . . . . . . 33
CFSEARCH variables . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

4 CFML Quick Reference
Standard CGI variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Request . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

CFML Quick Reference 5
CFML tags
cfabort
<cfabort
showError = "error_message">
cfapplet
<cfapplet
appletSource = "applet_name"
name = "form_variable_name"
height = "height_in_pixels"
width = "width_in_pixels"
vSpace = "space_above_and_below_in_pixels"
hSpace = "space_on_each_side_in_pixels"
align = "alignment_option"
notSupported = "message_to_display_for_nonJava_browser"
param_1 = "applet_parameter_name"
param_2 = "applet_parameter_name"
param_n = "applet_parameter_name">
cfapplication
<cfapplication
name = "application_name"
loginStorage = "cookie" or "session"
clientManagement = "Yes" or "No"
clientStorage = "datasource_name" or "Registry" or
"Cookie"
setClientCookies = "Yes" or "No"
sessionManagement = "Yes" or "No"
sessionTimeout = #CreateTimeSpan(days, hours, minutes,
seconds)#
applicationTimeout = #CreateTimeSpan(days, hours,
minutes, seconds)#
setDomainCookies = "Yes" or "No">
cfargument
<cfargument
name="string"
type="data type"
required="Yes or No"
default="default value"
displayname="descriptive name"
hint="extended description">
cfassociate
<cfassociate
baseTag = "base_tag_name"
dataCollection = "collection_name">
cfbreak
<cfbreak>
cfcache
<cfcache
action = "action"
directory = "directory_name"
timespan = "value"
expireURL = "wildcarded_URL_reference"
username = "username"
password = "password"
port = "port_number"
protocol = "protocol">
cfcase
<cfcase
value = "value or delimited set of values"
delimiters = "delimiter characters">
cfcatch
<cfcatch type = "exceptiontype">
Exception processing code here
</cfcatch>
cfchart
<cfchart
format = "flash, jpg, png"
chartHeight = "integer number of pixels"
chartWidth = "integer number of pixels"
scaleFrom = "integer minimum value"
scaleTo = "integer maximum value"
showXGridlines = "yes" or "no"
showYGridlines = "yes" or "no"
gridlines = "integer number of lines"
seriesPlacement = "default, cluster, stacked, percent"
foregroundColor = "Hex value or Web color"

6 CFML Quick Reference
dataBackgroundColor = "Hex value or Web color"
showBorder = "yes" or "no"
font = "font name"
fontSize = "integer font size"
fontBold = "yes" or "no"
fontItalic = "yes" or "no"
labelFormat = "number, currency, percent, date"
xAxisTitle = "title text"
yAxisTitle = "title text"
xAxisType = "scale or category"
yAxisType = "scale or category"
sortXAxis = "yes/no"
show3D = "yes" or "no"
xOffset = "number between -1 and 1"
yOffset = "number between -1 and 1"
rotated = "yes/no"
showLegend = "yes/no"
tipStyle = "MouseDown, MouseOver, none"
tipBGColor = "hex value or web color"
showMarkers = "yes" or "no"
markerSize = "integer number of pixels"
pieSliceStyle = "solid, sliced"
url = "onClick destination page"
name = "String"
</cfchart>
cfchartdata
<cfchartdata
item = "text"
value = "number">
cfchartseries
<cfchartseries
type="type"
query="queryName"
itemColumn="queryColumn"
valueColumn="queryColumn"
seriesLabel="Label Text"
seriesColor="Hex value or Web color"
paintStyle="plain, raise, shade, light"
markerStyle="style"
colorlist = "list">
</cfchartseries>
cfcol
<cfcol
header = "column_header_text"
width = "number_indicating_width_of_column"
align = "Left" or "Right" or "Center"
text = "column_text">
cfcollection
<cfcollection
action = "action"
collection = "collection_name"
path = "path_to_verity_collection"
language = "language"
name = "queryname" >
cfcomponent
<cfcomponent
extends ="anotherComponent"
output = "yes" or "no"
displayname = "text string">
hint = "text string">
variable declarations
<cffunction ...>
...
</cffunction>
<cffunction ...>
...
</cffunction>
</cfcomponent>
cfcontent
<cfcontent
type = "file_type"
deleteFile = "Yes" or "No"
file = "filename"
reset = "Yes" or "No">starting with a drive letter and a
colon, or a forward or backward slash

CFML Quick Reference 7
cfcookie
<cfcookie
name = "cookie_name"
value = "text"
expires = "period"
secure = "Yes" or "No"
path = "url"
domain = ".domain">
cfdefaultcase
<cfdefaultcase>
cfdirectory
<cfdirectory
action = "directory action"
directory = "directory name"
name = "query name"
filter = "list filter"
mode = "permission"
sort = "sort specification"
newDirectory = "new directory name">
cfdump
<cfdump
var = "#variable#"
expand = "Yes or No"
label = "text">
cfelse
<cfif expression>
HTML and CFML tags
<cfelseif expression>
HTML and CFML tags
<cfelse>
HTML and CFML tags
</cfif>
cfelseif
<cfif expression>
HTML and CFML tags
<cfelseif expression>
HTML and CFML tags
<cfelse>
HTML and CFML tags
</cfif>
cferror
<cferror
type = "a type"
template = "template_path"
mailTo = "email_address"
exception = "exception_type">
cfexecute
<cfexecute
name = " ApplicationName "
arguments = "CommandLine Arguments"
outputFile = "Output file name"
variable = "variable name"
timeout = "Timeout interval">
...
</cfexecute>
cfexit
<cfexit
method = "method">
cffile
<cffile
action = "append"
file = "full_path_name"
output = "string"
addNewLine = "Yes" or "No"
attributes = "file_attributes_list"
mode = "mode"
charset = "charset_option" >
<cffile
action = "copy"
source = "full_path_name"
destination = "full_path_name"
mode = "mode"
attributes = "file_attributes_list">
<cffile
action = "delete"
file = "full_path_name">

8 CFML Quick Reference
<cffile
action = "move"
source = "full_path_name"
destination = "full_path_name"
mode = "mode"
attributes = "file_attributes_list"
charset = "charset_option">
<cffile
action = "read"
file = "full_path_name"
variable = "var_name"
charset = "charset_option" >
<cffile
action = "readBinary"
file = "full_path_name"
variable = "var_name">
<cffile
action = "rename"
source = "full_path_name"
destination = "path_name"
mode = "mode"
attributes = "file_attributes_list">
<cffile
action = "upload"
fileField = "formfield"
destination = "full_path_name"
nameConflict = "behavior"
accept = "mime_type/file_type"
mode = "permission"
attributes = "file_attribute_or_list">
<cffile
action = "write"
file = "full_path_name"
output = "content"
mode = "permission"
addNewLine = "Yes" or "No"
attributes = "file_attributes_list"
charset = "charset_option" >
cfflush
<cfflush
interval = "integer number of bytes">
cfform
<cfform
name = "name"
action = "form_action"
preserveData = "Yes" or "No"
onSubmit = "javascript"
target = "window_name"
encType = "type"
passThrough = "HTML_attribute(s)"
codeBase = "URL"
archive = "URL"
scriptSrc = "path"
standard HTML attributes>
...
</cfform>
cfftp
cfftp: Opening and closing FTP server connections
<cfftp
action = "action"
username = "name"
password = "password"
server = "server"
timeout = "timeout in seconds"
port = "port"
connection = "name"
proxyServer = "proxy server"
retryCount = "number"
stopOnError = "Yes" or "No"
passive = "Yes" or "No">
cfftp: Connection: file and directory operations
<cfftp
action = "action"
username = "name"
password = "password"
name = "query_name"
server = "server"
ASCIIExtensionList = "extensions"
transferMode = "mode"
failIfExists = "Yes" or "No"

CFML Quick Reference 9
directory = "directory name"
localFile = "filename"
remoteFile = "filename"
item = "directory or file"
existing = "file or directory name"
new = "file or directory name"
proxyServer = "proxy server"
passive = "Yes" or "No">
cfftp action = "listDir"
<cfftp
action = "listDir"
</cfftp>
cffunction
<cffunction
name = "methodName"
returnType = "dataType"
roles = "securityRoles"
access = "methodAccess"
output = "yes" or "no"
displayName = "name"
Hint = "hint text">
cfgraph See cfchart
cfgraphdata See cfchartdata
cfgrid
<cfgrid
name = "name"
height = "integer"
width = "integer"
autoWidth = "Yes" or "No"
vSpace = "integer"
hSpace = "integer"
align = "value"
query = "query_name"
insert = "Yes" or "No"
delete = "Yes" or "No"
sort = "Yes" or "No"
font = "column_font"
fontSize = "size"
italic = "Yes" or "No"
bold = "Yes" or "No"
textColor = "web color"
href = "URL"
hrefKey = "column_name"
target = "URL_target"
appendKey = "Yes" or "No"
highlightHref = "Yes" or "No"
onValidate = "javascript_function"
onError = "text"
gridDataAlign = "position"
gridLines = "Yes" or "No"
rowHeight = "pixels"
rowHeaders = "Yes" or "No"
rowHeaderAlign = "position"
rowHeaderFont = "font_name"
rowHeaderFontSize = "size"
rowHeaderItalic = "Yes" or "No"
rowHeaderBold = "Yes" or "No"
rowHeaderTextColor = "web color"
colHeaders = "Yes" or "No"
colHeaderAlign = "position"
colHeaderFont = "font_name"
colHeaderFontSize = "size"
colHeaderItalic = "Yes" or "No"
colHeaderBold = "Yes" or "No"
colHeaderTextColor = "web color"
bgColor = "web color"
selectColor = "web color"
selectMode = "mode"
maxRows = "number"
notSupported = "text"
pictureBar = "Yes" or "No"
insertButton = "text"
deleteButton = "text"
sortAscendingButton = "text"
sortDescendingButton = "text">
</cfgrid>

10 CFML Quick Reference
cfgridcolumn
<cfgridcolumn
name = "column_name"
header = "header"
width = "column_width"
font = "column_font"
fontSize = "size"
italic = "Yes" or "No"
bold = "Yes" or "No"
textColor = "web color" or "expression"
bgColor = "web color" or "expression"
href = "URL"
hrefKey = "column_name"
target = "URL_target"
select = "Yes" or "No"
display = "Yes" or "No"
type = "type"
headerFont = "font_name"
headerFontSize = "size"
headerItalic = "Yes" or "No"
headerBold = "Yes" or "No"
headerTextColor = "web color"
dataAlign = "position"
headerAlign = "position"
numberFormat = "format"
values = "Comma separated strings and/or numeric range"
valuesDisplay = "Comma separated strings and/or numeric
range"
valuesDelimiter = "delimiter character">
cfgridrow
<cfgridrow
data = "col1, col2, ...">
cfgridupdate
<cfgridupdate
grid = "gridname"
dataSource = "data source name"
tableName = "table name"
username = "data source username"
password = "data source password"
tableOwner = "table owner"
tableQualifier = "qualifier"
keyOnly = "Yes" or "No">
cfheader
<cfheader
name = "header_name"
value = "header_value"
charset="charset">
OR
<cfheader
statusCode = "status_code"
statusText = "status_text">
cfhtmlhead
<cfhtmlhead
text = "text">
cfhttp
<cfhttp
url = "server_URL"
port = "port_number"
method = "method_name"
proxyServer = "hostname"
proxyPort = "port_number"
proxyUser = "username"
proxyPassword = "password"
username = "username"
password = "password"
userAgent = "user_agent"
charset = "character encoding"
resolveURL = "yes" or "no"
throwOnError = "yes" or no"
redirect = "yes" or "no"
timeout = "timeout_period"
getasbinary = "yes or no"
multipart = "yes or no"
path = "path"
file = "filename"
name = "queryname"
columns = "query_columns"
firstrowasheaders = "yes" or "no"

CFML Quick Reference 11
delimiter = "character"
textQualifier = "character">
cfhttpparam
<cfhttpparam
type = "transaction type"
name = "data name"
value = "data value"
file = "filename"
encoded = "Yes or No"
mimeType = "MIME type designator">
cfif
<cfif expression>
HTML and CFML tags
<cfelseif expression>
HTML and CFML tags
<cfelse>
HTML and CFML tags
</cfif>
cfimport
<cfimport
taglib = "taglib-location"
prefix = "custom">
cfinclude
<cfinclude
template = "template_name">
cfindex
<cfindex
collection = "collection_name"
action = "action"
type = "type"
title = "title"
key = "ID"
body = "body"
custom1 = "custom_value"
custom2 = "custom_value"
URLpath = "URL"
extensions = "file_extensions"
query = "query_name"
recurse = "Yes" or "No"
language = "language">
cfinput
<cfinput
type = "input_type"
name = "name"
value = "initial_value"
required = "Yes" or "No"
range = "min_value, max_value"
validate = "data_type"
onValidate = "javascript_function"
pattern = "regexp"
message = "validation_msg"
onError = "text"
size = "integer"
maxLength = "integer"
checked
passThrough = "HTML_attributes">
cfinsert
<cfinsert
dataSource = "ds_name"
tableName = "tbl_name"
tableOwner = "owner"
tableQualifier = "tbl_qualifier"
username = "username"
password = "password"
formFields = "formfield1, formfield2, ...">
cfinvoke
<!--- Syntax 1 - this syntax invokes a method of a
component. --->
<cfinvoke
component = "component name or reference"
method = "method name"
returnVariable = "variable name"
argumentCollection = "argument collection"
...>
OR

12 CFML Quick Reference
<!--- Syntax 2 - this syntax can invoke a method of a
component only from within the component. --->
<cfinvoke
method = "method name"
returnVariable = "variable name"
argumentCollection = "argument collection"
...>
OR
<!--- Syntax 3 - this syntax invokes a web service. --->
<cfinvoke
webservice = "URLtoWSDL_location"
method = "operation_name"
username = user name"
password = "password"
timeout = "request timeout in seconds"
proxyServer = "WSDL proxy server URL
proxyPort = "port on proxy server"
proxyUser = "user id for proxy server"
proxyPassword = "password for proxy server"
inputParam1 = "value1"
inputParam2 = "value2"
...
returnVariable = "var_name"
...>
OR
<!--- Syntax 4A - this syntax invokes a component.
This syntax shows instantiation with the cfobject tag.
This cfinvoke syntax applies to instantiating a component
with the cfobject tag and to instantiating a component
with the createobject function. --->
<cfobject
component = "component name"
name = "mystringname for instantiated object">
<cfinvoke
<!--- value is object name, within pound signs --->
component = "#mystringname for instantiated component#"
method = "method name"
returnVariable = "variable name"
argumentCollection = "argument collection"
...>
OR
<!--- Syntax 4B - this syntax invokes a web service.
This syntax shows instantiation with the cfobject tag.
This cfinvoke syntax applies to instantiating a web service
with the cfobject tag and to instantiating a web service
with the createobject function. --->
<cfobject
webservice = "web service name"
name = "mystringname for instantiated object"
method = "operation_name">
<cfinvoke
<!--- value is object name, within pound signs --->
webservice = "#my stringname for instantiated web
service#"
timeout = "request timeout in seconds"
proxyServer = "WSDL proxy server url
proxyPort = "numeric port on proxy server"
proxyUser = "string user id for proxy server"
proxyPassword = "string user password for proxy server">
cfinvokeargument
<cfinvokeargument
name="argument name"
value="argument value">
cfldap
<cfldap
server = "server_name"
port = "port_number"
username = "name"
password = "password"
action = "action"
name = "name"
timeout = "seconds"
maxRows = "number"
start = "distinguished_name"
scope = "scope"
attributes = "attribute, attribute"
filter = "filter"
sort = "attribute[, attribute]..."
sortControl = "nocase" and/or "desc" or "asc"
dn = "distinguished_name"
startRow = "row_number"

CFML Quick Reference 13
modifyType = "replace" or "add" or "delete"
rebind = "Yes" or "No"
referral = "number_of_allowed_hops"
secure = "multi_field_security_string"
separator = "separator_character"
delimiter = "delimiter_character">
cflocation
<cflocation
url = "url"
addToken = "Yes" or "No">
cflock
<cflock
timeout = "timeout in seconds "
scope = "Application" or "Server" or "Session"
name = "lockname"
throwOnTimeout = "Yes" or "No"
type = "readOnly" or "exclusive ">
<!--- CFML to be synchronized --->
</cflock>
cflog
<cflog
text = "text"
log = "log type"
file = "filename"
type = "message type"
application = "application name yes or no">
cflogin
<cflogin
idletimeout = "value"
applicationToken = "token"
cookieDomain = "domain"
...
<cfloginuser
name = "name"
password = "password-string"
roles = "roles">
...>
</cflogin>
cfloginuser
<cfloginuser
name = "name"
password = "password-string"
roles = "roles">
cflogout
<cflogout>
cfloop
<cfloop
index = "parameter_name"
from = "beginning_value"
to = "ending_value"
step = "increment">
... HTML or CFML code ...
</cfloop>
<cfloop
condition = "expression">
...
</cfloop>
<cfloop
query = "query_name"
startRow = "row_num"
endRow = "row_num">
</cfloop>
<cfloop
index = "index_name"
list = "list_items"
delimiters = "item_delimiter">
...
</cfloop>
cfmail
<cfmail
to = "recipient"
from = "sender"
cc = "copy_to"
bcc = "blind_copy_to"
subject = "msg_subject"
replyto = "reply_to_addr"
failto = "fail_message_addr"

14 CFML Quick Reference
username = "user name"
password = "password"
wraptext = "column number"
charset = "character encoding"
type = "msg_type"
mimeattach = "path"
query = "query_name"
group = "query_column"
groupcasesensitive = "yes" or "no"
startrow = "query_row"
maxrows = "max_msgs"
server = "serverspecs"
port = "port_id"
mailerid = "headerid"
timeout = "seconds"
spoolenable = "yes" or "no">
cfmailparam
<cfmail
to = "recipient"
subject = "msg_subject"
from = "sender"
...more attributes... >
<cfmailparam
file = "file-name"
type ="media type">
OR
<cfmailparam
name = "header-name"
value = "header-value" >
...
</cfmail>
cfmailpart
<cfmail
... >
(Optional cfmailparam entries)
<cfmailpart
type="mime type"
charset="character encoding"
wraptext="number">
...
</cfmail>
cfmodule
<cfmodule
template = "path"
name = "tag_name"
attributeCollection = "collection_structure"
attribute_name1 = "valuea"
attribute_name2 = "valueb"
...>
cfobject
<cfobject
type = "com"
action = "action"
class = "program_ID"
name = "text"
context = "context"
server = "server_name">
<cfobject
name = "variable name"
component = "component name">
<cfobject
type = "corba"
context = "context"
class = "file or naming service"
name = "text"
locale = "type-value arguments">
<cfobject
type = "Java"
action = "Create"
class = "Java class"
name = "object name">
<cfobject
webservice= "http://....?wsdl" or "name set in
Administrator"
name = "myobjectname">

CFML Quick Reference 15
cfobjectcache
<cfobjectcache
action = "clear">
cfoutput
<cfoutput
query = "query_name"
group = "query_column"
groupCaseSensitive = "Yes" or "No"
startRow = "start_row"
maxRows = "max_rows_output">
</cfoutput>
cfparam
<cfparam
name = "param_name"
type = "data_type"
default = "value">
cfpop
<cfpop
server = "servername"
port = "port_number"
username = "username"
password = "password"
action = "action"
name = "queryname"
messageNumber = "number"
uid = "number"
attachmentPath = "path"
timeout = "seconds"
maxRows = "number"
startRow = "number"
generateUniqueFilenames = "boolean">
cfprocessingdirective
<cfprocessingdirective
pageencoding = "page-encoding literal string" />
OR
<cfprocessingdirective
suppressWhiteSpace = "Yes" or "No"
pageEncoding = "page-encoding literal string">
CFML tags
</cfprocessingdirective>
cfprocparam
<cfprocparam
type = "in" or "out" or "inout"
variable = "variable name"
value = "parameter value"
CFSQLType = "parameter datatype"
maxLength = "length"
scale = "decimal places"
null = "Yes" or "No">
cfprocresult
<cfprocresult
name = "query_name"
resultSet = "1-n"
maxRows = "maxrows">
cfproperty
<cfproperty
name="name"
type="type"
required="boolean"
default="default value"
displayname="descriptive name"
hint="extended description">
cfquery
<cfquery
name = "query_name"
dataSource = "ds_name"
dbtype = "query"
username = "username"
password = "password"
maxRows = "number"
blockFactor = "blocksize"
timeout = "seconds"
cachedAfter = "date"
cachedWithin = "timespan"
Either of the following:
debug = "Yes" or "No"

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"

CFML Quick Reference 17
interval = "seconds"
requestTimeOut = "seconds"
username = "username"
password = "password"
proxyServer = "hostname"
proxyPort = "port_number">
proxyUser = "username"
proxyPassword = "password"
resolveURL = "Yes" or "No"
<cfschedule
action = "delete"
task = "TaskName">
<cfschedule
action = "run"
task = "TaskName">
cfscript
<cfscript>
cfscript code here
</cfscript>
cfsearch
<cfsearch
name = "search_name"
collection = "collection_name"
type = "criteria"
criteria = "search_expression"
maxRows = "number"
startRow = "row_number"
language = "language">
cfselect
<cfselect
name = "name"
required = "Yes" or "No"
message = "text"
onError = "text"
size = "integer"
multiple = "Yes" or "No"
query = "queryname"
selected = "column_value"
value = "text"
display = "text"
passThrough = "HTML_attributes">
</cfselect>
cfset
<cfset
var variable_name = expression>
cfsetting
<cfsetting
enableCFoutputOnly = "Yes" or "No"
showDebugOutput = "Yes" or "No"
requestTimeOut = "value in seconds" >
cfsilent
<cfsilent>
...
</cfsilent>
cfslider
<cfslider
name = "name"
label = "text"
refreshLabel = "Yes" or "No"
range = "min_value, max_value"
scale = "uinteger"
value = "integer"
onValidate = "script_name"
message = "text"
onError = "text"
height = "integer"
width = "integer"
vSpace = "integer"
hSpace = "integer"
align = "alignment"
tickMarkMajor = "Yes" or "No"
tickMarkMinor = "Yes" or "No"
tickMarkImages = "URL1, URL2, URLn"
tickMarkLabels = "Yes" or "No" or "list"
lookAndFeel = "motif" or "windows" or "metal"
vertical = "Yes" or "No"
bgColor = "color"
textColor = "color"

18 CFML Quick Reference
font = "font_name"
fontSize = "integer"
italic = "Yes" or "No"
bold = "Yes" or "No"
notSupported = "text">
cfstoredproc
<cfstoredproc
procedure = "procedure name"
dataSource = "ds_name"
username = "username"
password = "password"
blockFactor = "blocksize"
debug = "Yes" or "No"
returnCode = "Yes" or "No">
cfswitch
<cfswitch
expression = "expression">
One or more cfcase tags
Zero or one cfdefaultcase tags
</cfswitch>
cftable
<cftable
query = "query_name"
maxRows = "maxrows_table"
colSpacing = "number_of_spaces"
headerLines = "number_of_lines"
HTMLTable
border
colHeaders
startRow = "row_number">
...
</cftable>
cftextinput
<cftextinput
name = "name"
value = "text"
required = "Yes" or "No"
range = "min_value, max_value"
validate = "data_type"
pattern = "Java regular expression"
onValidate = "script_name"
message = "text"
onError = "text"
size = "integer"
font = "font_name"
fontSize = "integer"
italic = "Yes" or "No"
bold = "Yes" or "No"
height = "integer"
width = "integer"
vSpace = "integer"
hSpace = "integer"
align = "alignment"
bgColor = "color"
textColor = "color"
maxLength = "integer"
notSupported = "text">
cfthrow
<cfthrow
type = "exception_type "
message = "message"
detail = "detail_description "
errorCode = "error_code "
extendedInfo = "additional_information"
object = "java_except_object">
OR
<cfthrow
object = #object_name#>
cftrace
<cftrace
abort = "Yes or No"
category = "string"
inline = "Yes or No"
text = "string"
type = "format"
var = "variable_name"
</cftrace>

CFML Quick Reference 19
cftransaction
<cftransaction
action = "begin" or "commit" or "rollback"
isolation = "read_uncommitted" or "read_committed" or
"repeatable_read" >
</cftransaction>
cftree
<cftree name = "name"
required = "Yes" or "No"
delimiter = "delimiter"
completePath = "Yes" or "No"
appendKey = "Yes" or "No"
highlightHref = "Yes" or "No"
onValidate = "script_name"
message = "text"
onError = "text"
lookAndFeel = "motif" or "windows" or "metal"
font = "font"
fontSize = "size"
italic = "Yes" or "No"
bold = "Yes" or "No"
height = "integer"
width = "integer"
vSpace = "integer"
hSpace = "integer"
align = "alignment"
border = "Yes" or "No"
hScroll = "Yes" or "No"
vScroll = "Yes" or "No"
notSupported = "text">
</cftree>
cftreeitem
<cftreeitem
value = "text"
display = "text"
parent = "parent_name"
img = "filename"
imgopen = "filename"
href = "URL"
target = "URL_target"
query = "queryname"
queryAsRoot = "Yes" or "No"
expand = "Yes" or "No">
cftry
<cftry>
Code that might throw an exception
One or more cfcatch blocks
</cftry>
cfupdate
<cfupdate
dataSource = "ds_name"
tableName = "table_name"
tableOwner = "name"
tableQualifier = "qualifier"
username = "username"
password = "password"
formFields = "field_names">
cfwddx
<cfwddx
action = "action"
input = "inputdata"
output = "resultvariablename"
topLevelVariable = "toplevelvariablenameforjavascript"
useTimeZoneInfo = "Yes" or "No"
validate = "Yes" or "No" >
cfxml
<CFXML
variable="xmlVarName"
caseSensitive="yes" or "no">

20 CFML Quick Reference
CFML functions
Array functions
ArrayAppend(array, value)
ArrayAvg(array)
ArrayClear(array)
ArrayDeleteAt(array, position)
ArrayInsertAt(array, position, value)
ArrayIsEmpty(array)
ArrayLen(array)
ArrayMax(array)
ArrayMin(array)
ArrayNew(dimension)
ArrayPrepend(array, value)
ArrayResize(array, minimum_size)
ArraySet(array, start_pos, end_pos, value)
ArraySort(array, sort_type [, sort_order ])
ArraySum(array)
ArraySwap(array, position1, position2)
ArrayToList(array [, delimiter ])
IsArray(value [, number ])
ListToArray(list [, delimiters ])
Authentication functions
GetAuthUser()
IsUserInRole("role_name")
Conversion functions
ArrayToList(array [, delimiter ])
Hash(string)
LCase(string)
ListToArray(list [, delimiters ])
ToBase64(string or binary_object[, encoding])
ToBinary(string_in_Base64 or binary_value)
ToString(any_value [, encoding])
URLDecode(urlEncodedString [, charset])
URLEncodedFormat(string [, charset ])
Val(string)
XmlFormat(string)
XmlParse(xmlString [, caseSensitive ] )
XmlTransform(xmlString | xmlObj, xslString)
Date and time functions
CreateDate(year, month, day)
CreateDateTime(year, month, day, hour, minute, second)
CreateODBCDate(date)
CreateODBCDateTime(date)
CreateODBCTime(date)
CreateTime(hour, minute, second)
CreateTimeSpan(days, hours, minutes, seconds)
DateAdd("datepart", number, "date")
DateCompare("date1", "date2" [, "datePart"])
DateConvert("conversion-type", "date")
DateDiff("datepart", "date1", "date2")
DateFormat("date" [, "mask" ])
DatePart("datepart", "date")
Day("date")
DayOfWeek("date")