MACROMEDIA COLDFUSION 4.5- TO CFML User manual

Allaire Corporation
Quick Reference to CFML
© 1999 Allaire Corporation. All rights reserved.
This manual, as well as the software described in it, is furnished
under license and may be used or copiedonly in accordance with the
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 Allaire Corporation.
Allaire Corporation assumes no responsibility or liability for any
errors or inaccuracies that may appear in this book.
Except as permitted by such license, no part of this publication 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 Allaire
Corporation.
ColdFusion and HomeSite are federally registered trademarks of
Allaire Corporation. HomeSite, the ColdFusion logo, and the Allaire
logo are trademarks of Allaire Corporation in the USA and other
countries. Microsoft, Windows, Windows NT, Windows 95, Microsoft
Access, and FoxPro are registered trademarks of Microsoft
Corporation. All other products or name brands are the trademarks
of their respective holders. Solaris is a trademark of Sun
Microsystems Inc. UNIX is a trademark of The Open Group. PostScript
is a trademark of Adobe Systems Inc.
Part number: AA-45QKR-RK

Quick Reference to CFML iii
Contents
CFML Tags ............................................................. 1
CFML Functions .................................................. 12
Array functions .....................................................................12
Date and time functions ...................................................12
Decision functions ...............................................................13
Display and formatting functions ..................................13
Dynamic evaluation functions ........................................13
Format conversion functions ..........................................13
List functions .........................................................................14
International functions ......................................................14
Mathematical functions ....................................................14
Query functions ....................................................................15
String functions ....................................................................15
Structure functions .............................................................16
System functions .................................................................16
Other functions ....................................................................17
ColdFusion Variables ......................................... 18
Variable scope ......................................................................18
Client variables .....................................................................18
Server variables ....................................................................18
Application and session variables .................................18
Custom tag variables ..........................................................19
Request variable ..................................................................19
Form variable ........................................................................19
ColdFusion Tag-Specific Variables ................... 20
ColdFusion query variables .............................................20
CFCATCH variables ..............................................................20
CFDIRECTORY variables .....................................................21
CFERROR variables ..............................................................21
CFFILE ACTION=Upload variables .................................22
CFFTP error variables ..........................................................22
CFFTP ReturnValue variable ............................................22
CFFTP query object columns ...........................................23
CFHTTP variables .................................................................23
CFLDAP variables .................................................................23
CFPOP variables ...................................................................23
CFQUERY and CFSTOREDPROC variables ...................24
CFREGISTRY variables ........................................................24
CFSEARCH variables ...........................................................24
CFSERVLET variables ...........................................................24

iv Quick Reference to CFML
Standard CGI Variables ......................................25
Request ................................................................................... 25
Server ...................................................................................... 25
Client ....................................................................................... 25
ColdFusion Studio Keyboard Shortcuts ...........26
File and Document Keyboard Shortcuts .................... 26
Debugger Keyboard Shortcuts ...................................... 29

Quick Reference to CFML 1
CFML Tags
CFABORT
<CFABORT SHOWERROR="text">
CFAPPLET
<CFAPPLET APPLETSOURCE="applet_name"
NAME="form_variable_name"
HEIGHT="pixels"
WIDTH="pixels"
VSPACE="pixels"
HSPACE="pixels"
ALIGN="alignment"
NOTSUPPORTED="text"
param_1="value"
param_2="value"
param_n="value">
CFAPPLICATION
<CFAPPLICATION NAME="Name"
CLIENTMANAGEMENT="Yes" or "No"
CLIENTSTORAGE="Storage Type"
SETCLIENTCOOKIES="Yes" or "No"
SESSIONMANAGEMENT="Yes" or "No"
SESSIONTIMEOUT=#CreateTimeSpan(days, hours,
minutes, seconds)#
APPLICATIONTIMEOUT=#CreateTimeSpan(days, hours,
minutes, seconds)#
SETDOMAINCOOKIE="Yes" or "No">
CFASSOCIATE
<CFASSOCIATE BASETAG="tagname"
DATACOLLECTION="collectionname">
CFAUTHENTICATE
<CFAUTHENTICATE SECURITYCONTEXT="context"
USERNAME="user ID"
PASSWORD="password"
SETCOOKIE="Yes" or "No"
THROWONFAILURE="Yes" or "No">
CFBREAK
<CFBREAK>
CFCACHE
<CFCACHE
ACTION="action"
PROTOCOL="protocol name"
TIMEOUT="timeout date-time"
DIRECTORY="directory name for map file"
CACHEDIRECTORY="directory name for cached pages"
EXPIREURL="wildcarded URL reference"
PORT= "port-number ">
CFCOL
<CFCOL HEADER="text"
WIDTH="number"
ALIGN="position"
TEXT="text">
CFCOLLECTION
<CFCOLLECTION ACTION="action"
COLLECTION="collection"
PATH="implementation directory"
LANGUAGE="language">
CFCONTENT
<CFCONTENT TYPE="file_type"
DELETEFILE="Yes" or "No"
FILE="filename"
RESET="Yes" or "No">
CFCOOKIE
<CFCOOKIE NAME="cookie_name"
VALUE="text"
EXPIRES="period"
SECURE="Yes" or "No"
PATH="urls"
DOMAIN=".domain">

2QuickReferencetoCFML
CFDIRECTORY
<CFDIRECTORY ACTION="directory action"
DIRECTORY="directory name"
NAME="query name"
FILTER="list filter"
MODE="permission"
SORT="sort specification"
NEWDIRECTORY="new directory 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">
CFEXIT
<CFEXIT METHOD="method">
CFFILE
<CFFILE ACTION="Upload"
FILEFIELD="formfield"
DESTINATION="full_path_name"
NAMECONFLICT="behavior"
ACCEPT="mime_type" or "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">
CFFORM
<CFFORM NAME="name"
ACTION="form_action"
ENABLECAB="Yes" or "No"
ONSUBMIT="javascript"
TARGET="window_name"
ENCTYPE="type"
PASSTHROUGH="HTML_attributes">
...
</CFFORM>
CFFTP
<CFFTP ACTION="action"
USERNAME="name"
PASSWORD="password"
SERVER="server"
TIMEOUT="timeout in seconds"

Quick Reference to CFML 3
PORT="port"
CONNECTION="name"
PROXYSERVER="proxyserver"
PROXYBYPASS="proxybypass"
RETRYCOUNT="number"
STOPONERROR="Yes" or "No"
PASSIVE="Yes" or "No">
or
<CFFTP
ACTION="action"
USERNAME="name"
PASSWORD="password"
NAME="query_name"
SERVER="server"
ASCIIEXTENSIONLIST="extensions"
TRANSFERMODE="mode"
FAILIFEXISTS="Yes" or "No"
DIRECTORY="directory name"
LOCALFILE="filename"
REMOTEFILE="filename"
ATTRIBUTES="file attributes"
ITEM="directory or file"
EXISTING="file or directory name"
NEW="file or directory name"
PROXYSERVER="proxyserver"
PROXYBYPASS="proxybypass"
PASSIVE="Yes" or "No">
CFGRID
<CFGRID NAME="name"
HEIGHT="integer"
WIDTH="integer"
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"
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"
ROWHEADERWIDTH="col_width"
COLHEADERS="Yes" or "No"
COLHEADERALIGN="position"
COLHEADERFONT="font_name"
COLHEADERFONTSIZE="size"
COLHEADERITALIC="Yes" or "No"
COLHEADERBOLD="Yes" or "No"
BGCOLOR="color"
SELECTCOLOR="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"

4QuickReferencetoCFML
FONT="column_font"
FONTSIZE="size"
ITALIC="Yes" or "No"
BOLD="Yes" or "No"
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"
DATAALIGN="position"
HEADERALIGN="position"
NUMBERFORMAT="format">
CFGRIDROW
<CFGRIDROW DATA="col1, col2, ...">
CFGRIDUPDATE
<CFGRIDUPDATE GRID="gridname"
DATASOURCE="data source name"
DBTYPE="type"
DBSERVER="dbms"
DBNAME="database name"
TABLENAME="table name"
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">
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>

Quick Reference to CFML 5
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"
MESSAGE="validation_msg"
ONERROR="text"
SIZE="integer"
MAXLENGTH="integer"
CHECKED="Yes" or "No"
PASSTHROUGH="HTML_attributes">
CFINSERT
<CFINSERT DATASOURCE="ds_name"
DBTYPE="type"
DBSERVER="dbms"
DBNAME="database name"
TABLENAME="tbl_name"
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">

6QuickReferencetoCFML
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>
CFLOOP
<CFLOOP INDEX="parameter_name"
FROM="beginning_value"
TO="ending_value"
STEP="increment">
...
HTML or CFML code to execute
...
</CFLOOP>
or
<CFLOOP CONDITION="expression">
or
<CFLOOP QUERY="query_name"
STARTROW="row_num"
ENDROW="row_num">
or
<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"
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 "
...>

Quick Reference to CFML 7
CFOBJECT
<CFOBJECT TYPE="COM"
ACTION="action"
CLASS="program_ID"
NAME="text"
CONTEXT="context"
SERVER="server_name">
or
<CFOBJECT TYPE="CORBA"
CONTEXT="context"
CLASS="file or naming service"
NAME="text"
LOCALE="type-value arguments">
or
<CFOBJECT
TYPE="Java"
ACTION="Create"
CLASS="Java class"
NAME="object name">
CFOUTPUT
<CFOUTPUT MAXROWS="max_rows_output"
QUERY="query_name"
GROUP="query_column"
GROUPCASESENSITIVE="Yes" or "No"
STARTROW="start_row">
</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"
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">

8QuickReferencetoCFML
CFQUERY
<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="Yes" or "No">
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"
>
AND/OR ...additional criteria of the WHERE clause...
</CFQUERY>
CFREGISTRY
<CFREGISTRY ACTION="GetAll"
BRANCH="branch"
TYPE="data type"
NAME="query name"
SORT="criteria">
or
<CFREGISTRY ACTION="Get"
BRANCH="branch"
ENTRY="key or value"
TYPE="data type"
VARIABLE="variable">
or
<CFREGISTRY ACTION="Set"
BRANCH="branch"
ENTRY="key or value"
TYPE="value type"
VALUE="data">
or
<CFREGISTRY ACTION="Delete"
BRANCH="branch"
ENTRY="keyorvalue">
CFREPORT
<CFREPORT REPORT="report_path"
ORDERBY="result_order"
USERNAME="username"
PASSWORD="password"
FORMULA="formula">
</CFREPORT>
CFRETHROW
<CFRETHROW>
CFSCRIPT
<CFSCRIPT>
CFScript code goes here
</CFSCRIPT>

Quick Reference to CFML 9
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>
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"
CATCHEXCEPTIONBYPATTERN="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"

10 Quick Reference to CFML
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"
USERNAME="username"
PASSWORD="password"
DBSERVER="dbms"
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>
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>

Quick Reference to CFML 11
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"
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 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"
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">

12 Quick Reference to CFML
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 ])
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 )
DaysInMonth(
date )
Hour(
date )
IsDate(
string )
IsLeapYear(
year )
IsNumericDate(
number )
LSParseDateTime(
date-time-string )
Minute(
date )
Month(
date )
MonthAsString(
month_number )
Now()
ParseDateTime(
date-time-string [, pop-conversion ] )
Quarter(
date )
Second(
date )
Week(
date )
Year(
date )

Quick Reference to CFML 13
Decision functions
IsArray(value [, number ])
IsAuthenticated([
security-context-name ])
IsAuthorized(
resourcetype , resourcename [, action ])
IsBinary(
value )
IsBoolean(
value )
IsDate(
string )
IsDebugMode()
IsDefined("
variable_name ")
IsLeapYear(
year )
IsNumeric(
string )
IsNumericDate(
number )
IsQuery(
value )
IsSimpleValue(
value )
IsStruct(
variable )
LSIsCurrency(
string )
LSIsDate(
string )
LSIsNumeric(
string )
Display and formatting functions
DateFormat( date [, mask ])
DecimalFormat(
number )
DollarFormat(
number )
FormatBaseN(
number , radix )
HTMLCodeFormat(
string [, version ])
HTMLEditFormat(
string [, version ])
LSCurrencyFormat(
number [, type ])
LSDateFormat(
date [, mask ])
LSEuroCurrencyFormat(
currency-number [, type ])
LSNumberFormat(number [, mask ])
LSTimeFormat(
time [, mask ])
NumberFormat(
number [, mask ])
ParagraphFormat(
string )
PreserveSingleQuotes(
variable )
TimeFormat(
time [, mask ])
URLEncodedFormat(
string )
YesNoFormat(
value )
Dynamic evaluation functions
DE( string )
Evaluate(
string_expression1 [, string_expression2
[, … ] ] )
IIf(
condition , string_expression1 ,
string_expression2 )
SetVariable(
name , value )
Format conversion functions
JSStringFormat( string )
ToBase64(
string or binary_object )
ToBinary(
string_in_Base64 or binary_value )
URLDecode(
URL_encoded_string )
URLEncodedFormat(
string )
ToString(
any_value )
XMLFormat(
string )

14 Quick Reference to CFML
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 ])
International functions
DateConvert( conversion-type , date )
GetLocale()
GetTimeZoneInfo()
LSCurrencyFormat(
number [, type ])
LSDateFormat(
date [, mask ])
LSEuroCurrencyFormat(
currency-number [, type ])
LSIsCurrency(
string )
LSNumberFormat(
number [, mask ])
LSParseCurrency(
string )
LSParseDateTime(
string )
LSParseEuroCurrency(
currency-string )
LSParseNumber(
string )
LSTimeFormat(
time [, mask ])
SetLocale(
new_locale)
Mathematical functions
Abs( number )
ACos(
number )
ASin(
number )
Atn(
number )
BitAnd(
number1 , number2 )
BitMaskClear(
number , start , length )
BitMaskRead(
number , start , length )
BitMaskSet(
number , mask , start , length )
BitNot(
number )
BitOr(
number1 , number2 )
BitSHLN(
number , count )
BitSHRN(
number , count )
BitXor(
number1 , number2 )
Ceiling(
number )
Cos(
number )

Quick Reference to CFML 15
DecrementValue( number )
Exp(
number )
Fix(
number )
IncrementValue(
number )
InputBaseN(
string , radix )
Int(
number )
Log(
number )
Log10(
number )
Max(
number1 , number2 )
Min(
number1 , number2 )
Pi()
Rand()
Randomize(
number )
RandRange(
number1 , number2 )
Round(
number )
Sgn(
number )
Sin(
number )
Sqr(
number )
Tan(
number )
Query functions
IsQuery( value )
QueryAddColumn(
query , column-name , array-name )
QueryAddRow(
query [, number ])
QueryNew(
columnlist )
QuerySetCell(
query , column_name , value
[,
row_number ])
QuotedValueList(
query.column [, delimiter ])
ValueList(
query.column [, delimiter ])
String functions
Asc( string )
Chr(
number )
Cjustify(
string , length )
Compare(
string1 , string2 )
CompareNoCase(
string1 , string2 )
DayOfWeekAsString(
day_of_week )
FormatBaseN(
number , radix )
Find(
substring , string [, start ])
FindNoCase(
substring , string [, start ])
FindOneOf(
set , string [, start ])
GetToken(
string , index [, delimiters ])
Insert(
substring , string , position )
JSStringFormat(
string )
LCase(
string )
Left(
string , count )
Len(
string or binary_object )
ListValueCount(
list, value [, delimiters ])
ListValueCountNoCase(
list, value [, delimiters ])
LJustify(
string , length )
LSParseCurrency(
string )
LSParseDateTime(
date-time-string )
LSParseEuroCurrency(
currency-string )
LSParseNumber(
string )
LTrim(
string )
Mid(
string , start , count )
MonthAsString(
month_number )

16 Quick Reference to CFML
ParseDateTime( string1 [, string2 ] )
REFind(
reg_expression , string [, start ]
[,
returnsubexpressions ] )
REFindNoCase(
reg_expression , string [, start ]
[,
returnsubexpressions ] )
RemoveChars(
string , start , count )
RepeatString(
string , count )
Replace(
string , substring1 , substring2 [, scope ])
ReplaceList(
string , list1 , list2 )
ReplaceNoCase(
string , substring1 , substring2
[,
scope ])
REReplace(
string , reg_expression , substring
[, scope ])
REReplaceNoCase(
string , reg_expression ,
substring
[, scope ])
Reverse(
string )
Right(
string , count )
RJustify(
string , length )
RTrim(
string )
SpanExcluding(
string , set )
SpanIncluding(
string , set )
StripCR(
string )
ToString(
any_value )
Trim(
string )
UCase(
string )
Val(
string )
XMLFormat(
string )
Structure functions
IsStruct( variable )
StructClear(
structure )
StructCopy(
structure )
StructCount(
structure )
StructDelete(
structure , key [, indicatenotexisting ])
StructFind(
structure , key )
StructInsert(
structure , key , value
[,
allowoverwrite ])
StructIsEmpty(
structure )
StructKeyArray(
structure )
StructKeyExists(structure, key)
StructKeyList(
structure [, delimiter ])
StructNew()
StructUpdate(
structure , key , value )
System functions
DirectoryExists( absolute_path )
ExpandPath(
relative_path )
FileExists(
absolute_path )
GetBaseTemplatePath()
GetCurrentTemplatePath()
GetDirectoryFromPath(
path )
GetFileFromPath(
path )
GetMetricData(
monitor_name )
GetProfileString(
IniPath , Section, Entry )
GetTempDirectory()
GetTempFile(
dir , prefix )
†GetTemplatePath()
SetProfileString(
IniPath, Section, Entry, Value )

Quick Reference to CFML 17
Other functions
AuthenticatedUser()
AuthenticatedContext()
CreateObject("COM",
class or
progid , "INPROC or LOCAL or REMOTE ", , servername )
CreateObject("CORBA",
filename or
naming_context_name , IOR or naming_service ,
int_orb_args , )
CreateObject("JAVA",
classname )
CreateUUID()
Decrypt(
encrypted_string , key )
DeleteClientVariable("
name ")
Encrypt(
string , key )
GetBaseTagData(
tagname [, instancenumber ] )
GetBaseTagList()
GetClientVariablesList()
GetFunctionList()
GetTickCount()
†ParameterExists(
parameter )
PreserveSingleQuotes(
variable )
URLDecode(
URL_encoded_string )
URLEncodedFormat(
string )
WriteOutput(
string )
XMLFormat(
string )
†Deprecated.