MACROMEDIA COLDFUSION 5-CFML User manual

Macromedia® Incorporated
CFML Quick Reference
© 2001 Macromedia Incorporated. All rights reserved.
This manual, as wellas the software described in it, is furnished
underlicenseandmaybeusedorcopiedonlyinaccordancewiththe
terms of such license. The content of this manual is furnished for
informational use only, is subject to change without notice, and
should not be construed as a commitment by Macromedia
Incorporated. Macromedia Incorporated assumes no responsibility
orliabilityforanyerrorsorinaccuraciesthatmayappearinthisbook.
Except as permitted by such license, no part of thispublication may
be reproduced, stored in a retrieval system, or transmitted in any
form or by any means, electronic, mechanical, recording, or
otherwise, without the prior written permission of Macromedia
Incorporated.
ColdFusion and HomeSite are federally registered trademarks of
MacromediaIncorporated. HomeSite, the ColdFusion logo and the
Allaire logo are trademarks of Macromedia Incorporated in the USA
andothercountries.Microsoft,Windows,WindowsNT,Windows95,
MicrosoftAccess,andFoxPro areregisteredtrademarksofMicrosoft
Corporation. Solaris is a trademark of Sun Microsystems Inc. UNIX is
a trademark of The Open Group. PostScript is a trademark of Adobe
Systems Inc. All other products or name brands are the trademarks
of their respective holders.
Part number: ZCF50MQKREF

CFMLQuickReference iii
Contents
CFMLTags ............................................................. 1
CFMLFunctions ..................................................14
Array functions .....................................................................14
Authenticationfunctions ..................................................14
Conversion functions .........................................................14
Date and time functions ...................................................14
Decision functions ...............................................................15
Displayandformattingfunctions ..................................15
Dynamicevaluationfunctions ........................................16
Internationalfunctions ......................................................16
ListFunctions ........................................................................16
Mathematicalfunctions ....................................................17
Queryfunctions ....................................................................17
Stringfunctions ....................................................................17
Structure functions .............................................................18
System functions .................................................................19
Other functions ....................................................................19
ColdFusion Variables .........................................20
Variablescope ......................................................................20
Client variables .....................................................................20
Server variables ....................................................................20
Application and session variables .................................20
Custom tag variables ..........................................................21
Request variable ..................................................................21
Formvariable ........................................................................21
ColdFusion Tag-Specific Variables ...................22
ColdFusion query variables .............................................22
CFCATCHvariables ..............................................................22
CFDIRECTORY variables .....................................................23
CFERRORvariables ..............................................................23
CFFILE ACTION=Upload variables .................................24
CFFTP error variables ..........................................................24
CFFTP ReturnValuevariable ............................................24
CFFTP query object columns ...........................................25
CFHTTP variables .................................................................25
CFLDAP variables .................................................................25
CFPOP variables ...................................................................25
CFQUERY and CFSTOREDPROC variables ...................26
CFREGISTRYvariables ........................................................26
CFSEARCH variables ...........................................................26

iv CFMLQuickReference
CFSERVLETvariables ..........................................................26
Standard CGI Variables ......................................27
Request ...................................................................................27
Server ......................................................................................27
Client .......................................................................................27
ColdFusion StudioKeyboard Shortcuts ...........28
File and document keyboard shortcuts ..................... 28
Debugger Keyboard Shortcuts ...................................... 31

CFMLQuickReference 1
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 = "Left" or "Right" or "Bottom" or "Top" or "TextTop"
or "Middle" or "AbsMiddle" or "Baseline" or "AbsBottom"
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"
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">
cfassociate
<cfassociate baseTag = "base_tag_name"
dataCollection = "collection_name">
cfauthenticate
<cfauthenticate securityContext = "security_context"
username = "user_ID"
password = "password"
setCookie = "Yes" or "No"
throwOnFailure = "Yes" or "No"
authType = "Basic" or "X509">
cfbreak
<cfbreak>
cfcache
<cfcache action = "cache" or "flush" or "clientCache"
or "optimal"
username = "username"
password = "password"
protocol = "protocol_name"
timeout = "#DateAdd(datepart, number, date)#"
directory = "directory_name_for_map_file"
cacheDirectory = "directory_name_for_cached_pages"
expireURL = "wildcarded_URL_reference"
port = "port_number">
cfcol
<cfcol header = "column_header_text"
width = "number_indicating_width_of_column"
align = "Left" or "Right" or "Center"
text = "text_indicating_type_of_text">
cfcollection
<cfcollection action = "create" or "repair" or
"delete" or "optimize" or "map"
collection = "collection_name"
path = "path_of_verity_directory"
language = "English" or "German" or "Finnish"
or "French" or "Danish" or "Dutch" or "Italian"
or "Norwegian" or "Portuguese" or "Spanish"
or "Swedish">
cfcontent
<cfcontent type = "file_type"
deleteFile = "Yes" or "No"
file = "filename"
reset = "Yes" or "No">

2CFMLQuickReference
cfcookie
<cfcookie name = "cookie_name"
value = "text"
expires = "period"
secure = "Yes" or "No"
path = "url"
domain = ".domain">
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_name>
cferror
<cferror type = "request" or "validation" or "monitor"
or "exception"
template = "template_path"
mailTo = "email_address"
exception = "exception_type">
cfexecute
<cfexecute name = " ApplicationName "
arguments = "CommandLine Arguments"
outputFile = "Output file name"
timeout = "Timeout interval in seconds">
...
</cfexecute>
cfexit
<cfexit method = "method">
cffile
<cffile action = "upload"
fileField = "formfield"
destination = "full_path_name"
nameConflict = "behavior"
accept = "mime_type/file_type"
mode = "permission"
attributes = "file_attributes">
<cffile action = "move"
source = "full_path_name"
destination = "full_path_name"
attributes = "file_attributes">
<cffile action = "rename"
source = "full_path_name"
destination = "full_path_name"
attributes = "file_attributes">
<cffile action = "copy"
source = "full_path_name"
destination = "full_path_name"
attributes = "file_attributes">
<cffile action = "delete"
file = "full_path_name">
<cffile action = "read"
file = "full_path_name"
variable = "var_name">
<cffile action = "readBinary"
file = "full_path_name"
variable = "var_name">
<cffile action = "write"
file = "full_path_name"
output = "content"
mode = "permission"
addNewLine = "Yes" or "No"
attributes = "file_attributes">
<cffile action = "append"
file = "full_path_name"
output = "string"
attributes = "file_attributes">
cfflush
<cfflush interval = integer number of bytes>
cfform
<cfform name = "name"
action = "form_action"
preserveData = "Yes" or "No"

CFMLQuickReference 3
enableCAB = "Yes" or "No"
onSubmit = "javascript"
target = "window_name"
encType = "type"
passThrough = "HTML_attributes"
codeBase = "URL"
archive = "URL" >
...
</cfform>
cfftp
<cfftp action = "establish_FTP_connection"
username = "name"
password = "password"
server = "server"
timeout = "timeout in seconds"
port = "port"
connection = "name"
proxyServer = "proxyserver"
retryCount = "number"
stopOnError = "Yes" or "No"
passive = "Yes" or "No">
<cfftp action = "file_or_dir_operation"
username = "name"
password = "password"
name = "query_name"
server = "server"
ASCIIExtensionList = "extensions"
transferMode = "mode"
failIfExists = "Yes" or "No"
directory = "directory name"
localFile = "filename"
remoteFile = "filename"
item = "directory or file"
existing = "file or directory name"
new = "file or directory name"
proxyServer = "proxyserver"
passive = "Yes" or "No">
cfgraph
<cfgraph type = "bar" or "horizontalBar"
query = "query name"
valueColumn = "query column"
itemColumn = "query column"
URL = "URL string"
URLColumn = "query column"
showValueLabel = "yes", "no", or "rollover"
valueLabelFont = "Arial", "Courier", or "Times"
valueLabelSize = number of points
valueLocation = "onBar" or "overBar"
scaleFrom = integer minimum value
scaleTo = integer maximum value
showItemLabel = "yes" or "no"
itemLabelFont = "Arial", "Courier", or "Times"
itemLabelSize = number of points
itemLabelOrientation = "horizontal" or "vertical"
title = "title text"
titleFont = "Arial", "Courier", or "Times"
fileFormat = "Flash", "gif" or "jpg"
barSpacing = integer number of pixels
graphHeight = integer number of pixels
graphWidth = integer number of pixels
backgroundColor = "Web color"
borderColor = "Web color"
borderWidth = integer number of pixels
depth = integer number of pixels
colorList = "Web color list"
gridLines = integer number of lines>
...
</cfgraph>
<cfgraph type = "line"
query = "query name"
valueColumn = "query column"
itemColumn = "query column"
scaleFrom = integer minimum value
scaleTo = integer maximum value
showItemLabel = "yes" or "no"
itemLabelFont = "Arial", "Courier", or "Times"
itemLabelSize = number of points
itemLabelOrientation = "horizontal" or "vertical"
title = "title text"
titleFont = "Arial", "Courier", or "Times"

4CFMLQuickReference
fileFormat = "Flash", "gif" or "jpg"
lineColor = "Web color"
lineWidth = integer number of pixels
fill = "yes" or "no"
graphHeight = integer number of pixels
graphWidth = integer number of pixels
backgroundColor = "Web color"
borderColor = "Web color"
borderWidth = integer number of pixels
depth = integer number of pixels
gridLines = integer number of lines>
...
</cfgraph>
<cfgraph type = "pie"
query = "query name"
valueColumn = "query column"
itemColumn = "query column"
<!--- data drill down attributes --->
URL = "URL string"
URLColumn = "query column"
<!--- pie chart value display attributes --->
showValueLabel = "yes", "no", or "rollover"
valueLabelFont = "Arial", "Courier", or "Times"
valueLabelSize = number of points
valueLocation = "inside" or "outside"
title = "title text"
titleFont = "Arial", "Courier", or "Times"
showLegend = "above", "below", "left", "right",
or "none"
legendFont = "Arial", "Courier", or "Times"
fileFormat = "Flash", "gif" or "jpg"
graphHeight = integer number of pixels
graphWidth = integer number of pixels
backgroundColor = "Web color"
borderColor = "Web color"
borderWidth = integer number of pixels
depth = integer number of pixels
colorList = "Web color list">
...
</cfgraph>
cfgraphdata
<cfgraphdata item = "data item"
value = data value
item = "label string"
color = "Web color"
URL = "URL string">
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"

CFMLQuickReference 5
rowHeaderTextColor = "Web color"
rowHeaderWidth = "col_width"
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>
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"
colHeaderTextColor = "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"
dbType = "type"
dbServer = "dbms"
dbName = "database name"
tableName = "table name"
connectString = "connection string"
username = "data source username"
password = "data source password"
tableOwner = "table owner"
tableQualifier = "qualifier"
provider = "COMProvider"
providerDSN = "datasource"
keyOnly = "Yes" or "No">
cfheader
<cfheader
name = "header_name"
value = "header_value">
or
<cfheader
statusCode = "status_code"
statusText = "status_text">
cfhtmlhead
<cfhtmlhead text = "text">

6CFMLQuickReference
cfhttp
<cfhttp url = "hostname"
port = "port_number"
method = "get_or_post"
username = "username"
password = "password"
name = "queryname"
columns = "query_columns"
path = "path"
file = "filename"
delimiter = "character"
textQualifier = "character"
resolveURL = "yes" or "no"
proxyServer = "hostname"
proxyPort = "port_number"
userAgent = "user_agent"
throwOnError = "yes" or "no"
redirect = "yes" or "no"
timeout = "timeout_period">
</cfhttp>
cfhttpparam
<cfhttpparam name = "name"
type = "type"
value = "transaction type"
file = "filename">
cfif cfelseif cfelse
<cfif expression>
HTML and CFML tags
<cfelseif>
HTML and CFML tags
<cfelse expression>
HTML and CFML tags
</cfif>
cfimpersonate
<cfimpersonate
securityContext = "SecurityContext"
username = "Name"
password = "Password"
type = "CF" or "OS">
...
HTML or CFML code to execute
...
</cfimpersonate>
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"
external = "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">

CFMLQuickReference 7
cfinsert
<cfinsert dataSource = "ds_name"
dbType = "type"
dbServer = "dbms"
dbName = "database name"
tableName = "tbl_name"
connectString = "connection string"
tableOwner = "owner"
tableQualifier = "tbl_qualifier"
username = "username"
password = "password"
provider = "COMProvider"
providerDSN = "datasource"
formFields = "formfield1, formfield2, ...">
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"
filterFile = "<file_name>,<stanza_name>"
sort = "attribute[, attribute]..."
sortControl = "nocase" and/or "desc" or "asc"
dn = "distinguished_name"
startRow = "row_number"
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/Exclusive ">
<!--- CFML to be synchronized --->
</cflock>
cflog
<cflog text = "text"
log = "log type"
file = "filename"
type = "message type"
thread = "thread ID yes or no"
date = "date yes or no"
time = "time yes or no"
application = "application name yes or no">
cfloop
<cfloop index = "parameter_name"
from = "beginning_value"
to = "ending_value"
step = "increment">
...
HTML or CFML code to execute
...
</cfloop>
<cfloop condition = "expression">
<cfloop query = "query_name"
startRow = "row_num"
endRow = "row_num">
<cfloop index = "index_name"
list = "list_items"
delimiterS = "item_delimiter">
</cfloop>

8CFMLQuickReference
cfmail
<cfmail to = "recipient"
from = "sender"
cc = "copy_to"
Bcc = "blind_copy_to"
subject = "msg_subject"
type = "msg_type"
maxRows = "max_msgs"
MIMEAttach = "path"
query = "query_name"
group = "query_column"
groupCaseSensitive = "Yes" or "No"
startRow = "query_row"
server = "servername"
port = "port_ID"
mailerID = "headerid"
timeout = "seconds">
cfmailparam
<cfmail
to = "recipient"
subject = "msg_subject"
from = "sender"
...more attibutes... >
<cfmailparam
file = "file-name" >
or
<cfmailparam
name = "header-name"
value = "header-value" >
...
</cfmail>
cfmodule
<cfmodule template = "template"
name = "tag_name"
attributeCollection = "collection_structure"
attribute_name1 = "value"
attribute_name2 = "value"
...>
cfobject
<cfobject type = "COM"
action = "action"
class = "program_ID"
name = "text"
context = "context"
server = "server_name">
<cfobject type = "CORBA"
context = "context"
class = "file or naming service"
name = "text"
locale = "type-value arguments">
<cfobject
action = "Create"
type = "Java"
class = "Java class"
name = "object name">
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"
attachmentPath = "path"

CFMLQuickReference 9
timeout = "seconds"
maxRows = "number"
startRow = "number"
generateUniqueFilenames = "boolean">
cfprocessingdirective
<cfprocessingdirective
suppressWhiteSpace = "Yes" or "No">
… any CFML tags here …
</cfprocessingdirective>
cfprocparam
<cfprocparam type = "IN or OUT or INOUT"
variable = "variable name"
dbVarName = "DB 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">
cfquery
<cfquery name = "query_name"
dataSource = "ds_name"
dbType = "type"
dbServer = "dbms"
dbName = "database name"
connectString = "connection string"
username = "username"
password = "password"
maxRows = "number"
blockFactor = "blocksize"
timeout = "milliseconds"
cachedAfter = "date"
cachedWithin = "timespan"
provider = "COMProvider"
providerDSN = "datasource"
debug>
SQL statements
</cfquery>
cfqueryparam
<cfquery name = "query_name"
dataSource = "ds_name"
...other attributes... >
SELECT STATEMENT WHERE column_name =
<cfqueryPARAM value = "parameter value"
CFSQLType = "parameter type"
maxLength = "maximum parameter length"
scale = "number of decimal places"
dbName = "database name"
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">

10 CFMLQuickReference
cfreport
<cfreport report = "report_path"
orderBy = "result_order"
username = "username"
password = "password"
formula = "formula">
</cfreport>
cfrethrow
<cfrethrow>
cfsavecontent
<cfsavecontent variable = "variable name">
content
</cfsavecontent>
cfschedule
<cfschedule action = "update"
task = "taskname"
operation = "HTTPRequest"
file = "filename"
path = "path_to_file"
startDate = "date"
startTime = "time"
url = "URL"
publish = "Yes" or "No"
endDate = "date"
endTime = "time"
interval = "seconds"
requestTimeOut = "seconds"
username = "username"
password = "password"
resolveURL = "Yes" or "No"
proxyServer = "hostname"
port = "port_number"
proxyPort = "port_number">
<cfschedule action = "delete" task = "TaskName">
<cfschedule action = "Run" task = "TaskName">
cfscript
<cfscript>
cfscript code goes here
</cfscript>
cfsearch
<cfsearch name = "search_name"
collection = "collection_name"
type = "criteria"
criteria = "search_expression"
maxRows = "number"
startRow = "row_number"
external = "Yes" or "No"
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>
cfservlet
<cfservlet code = "class name of servlet"
jrunProxy = "proxy server"
timeout = "timeout in seconds"
writeOutput = "Yes" or "No"
debug = "Yes" or "No">
<cfservletparam name = "parameter name"
value = "value">
...
</cfservlet>

CFMLQuickReference 11
cfservletparam
<cfservlet
...>
<cfservletparam name = "servlet parameter name"
value = "servlet parameter value">
...
<cfservletparam name = "servlet attribute name"
variable = "coldfusion variable name"
type = "INT" or "DOUBLE" or "BOOL" or "DATE" or "STRING">
...
</cfservlet>
cfset
<cfset variable_name = expression>
cfsetting
<cfsetting enableCFoutputOnly = "Yes" or "No"
showDebugOutput = "Yes" or "No"
catchExceptionsByPattern = "Yes" or "No">
cfsilent
<cfsilent>
cfslider
<cfslider name = "name"
label = "text"
refreshLabel = "Yes" or "No"
img = "filename"
imgStyle = "style"
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"
grooveColor = "color"
bgColor = "color"
textColor = "color"
font = "font_name"
fontSize = "integer"
italic = "Yes" or "No"
bold = "Yes" or "No"
notSupported = "text">
cfstoredproc
<cfstoredproc procedure = "procedure name"
dataSource = "ds_name"
dbType = "type"
username = "username"
password = "password"
dbServer = "dbms"
connectString = "connection string"
dbName = "database name"
blockFactor = "blocksize"
provider = "COMProvider"
providerDSN = "datasource"
debug = "Yes" or "No"
returnCode = "Yes" or "No">
cfswitch cfcase cfdefaultcase
<cfswitch expression = "expression">
<cfcase value = "value" delimiters = "delimiters">
HTML and CFML tags
</cfcase>
additional <cfcase></cfcase> tags
<cfdefaultcase>
HTML and CFML tags
</cfdefaultcase>
</cfswitch>

12 CFMLQuickReference
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"
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 ">
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"

CFMLQuickReference 13
imgopen = "filename"
href = "URL"
target = "URL_target"
query = "queryname"
queryAsRoot = "Yes" or "No"
expand = "Yes" or "No">
cftry cfcatch
<cftry>
... Add code here
<cfcatch type = "exceptiontype">
... Add exception processing code here
</cfcatch>
... Additional cfcatch blocks go here
</cftry>
cfupdate
<cfupdate dataSource = "ds_name"
dbType = "type"
dbServer = "dbms"
dbName = "database name"
connectString = "connection string"
tableName = "table_name"
tableOwner = "name"
tableQualifier = "qualifier"
username = "username"
password = "password"
provider = "COMProvider"
providerDSN = "datasource"
formFields = "field_names">
cfwddx
<cfwddx action = "action"
input = "inputdata"
output = "resultvariablename"
topLevelVariable = "toplevelvariablenameforjavascript"
useTimeZoneInfo = "Yes" or "No"
validate = "Yes" or "No">

14 CFMLQuickReference
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 [, delimiter ])
Authentication functions
AuthenticatedContext()
AuthenticatedUser()
IsAuthenticated([security-context-name ])
IsAuthorized(resourcetype, resourcename [, action ])
Conversion functions
Hash(string)
ToBase64(string or binary_object)
ToBinary(string_in_Base64 or binary_value)
ToString(any_value)
URLDecode(urlEncodedString)
URLEncodedFormat(string)
XMLFormat(string)
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)
DayOfWeekAsString(day_of_week)
DayOfYear(date)

CFMLQuickReference 15
DaysInMonth(date)
DaysInYear(date)
FirstDayOfMonth(date)
GetHttpTimeString(date_time_object)
GetTimeZoneInfo()
Hour(date)
IsDate(string)
IsLeapYear(year)
IsNumericDate(number)
LSDateFormat(date [, mask ])
LSIsDate(string)
LSParseDateTime(date/time-string)
LSTimeFormat(time [, mask ])
Minute(date)
Month(date)
MonthAsString(month_number)
Now()
ParseDateTime(date/time-string [, pop-conversion ] )
Quarter(date)
Second(date)
TimeFormat(time [, mask ])
Week(date)
Year(date)
Decisionfunctions
IsArray(value [, number ])
IsAuthenticated([security-context-name ])
IsAuthorized(resourcetype, resourcename [, action ])
FileExists(absolute_path)
IsBinary(value)
IsBoolean(value)
IsCustomFunction(name)
IsDate(string)
IsDebugMode()
IsDefined("variable_name")
IsLeapYear(year)
IsNumeric(string)
IsNumericDate(number)
IsProtected(resourcetype, resourcename [, action])
IsQuery(value)
IsSimpleValue(value)
IsStruct(variable )
IsWDDX(value)
LSIsCurrency(string)
LSIsDate(string)
LSIsNumeric(string)
ParameterExists(parameter)
Display and formattingfunctions
DateFormat(date [, mask ])
DecimalFormat(number)
DollarFormat(number)
FormatBaseN(number, radix)
HTMLCodeFormat(string [, version ])
HTMLEditFormat(string [, version ])
LSCurrencyFormat(number [, type ])
LSDateFormat(date [, mask ])

16 CFMLQuickReference
LSEuroCurrencyFormat(currency-number [, type ])
LSNumberFormat(number [, mask ])
LSTimeFormat(time [, mask ])
NumberFormat(number [, mask ])
ParagraphFormat(string)
TimeFormat(time [, mask ])
YesNoFormat(value)
Dynamic evaluation functions
DE(string)
Evaluate(string_express1 [, string_express2 [,…]])
IIf(condition, string_express1, string_express2)
SetVariable(name, value)
Internationalfunctions
DateConvert(conversion-type, date)
GetHttpTimeString(date_time_object)
GetLocale()
GetTimeZoneInfo()
LSCurrencyFormat(number [, type ])
LSDateFormat(date [, mask ])
LSEuroCurrencyFormat(currency-number [, type ])
LSIsCurrency(string)
LSIsDate(string)
LSIsNumeric(string)
LSNumberFormat(number [, mask ])
LSParseCurrency(string)
LSParseDateTime(date/time-string)
LSParseEuroCurrency(currency-string)
LSParseNumber(string)
LSTimeFormat(time [, mask ])
SetLocale(new_locale)
List Functions
ArrayToList(array [, delimiter ])
ListAppend(list, value [, delimiters ])
ListChangeDelims(list, new_delimiter [, delimiters ])
ListContains(list, substring [, delimiters ])
ListContainsNoCase(list, substring [, delimiters ])
ListDeleteAt(list, position [, delimiters ])
ListFind(list, value [, delimiters ])
ListFindNoCase(list, value [, delimiters ])
ListFirst(list [, delimiters ])
ListGetAt(list, position [, delimiters ])
ListInsertAt(list, position, value [, delimiters ])
ListLast(list [, delimiters ])
ListLen(list [, delimiters ])
ListPrepend(list, value [, delimiters ])
ListQualify(list, qualifier [, delimiters ]
[, elements ])
ListRest(list [, delimiters ])
ListSetAt(list, position, value [, delimiters ])
ListSort(list, sort_type [, sort_order] [, delimiter])
ListToArray(list [, delimiter ])
ListValueCount(list, value [, delimiters ])
ListValueCountNoCase(list, value [, delimiters ])