This document is being compiled for inclusion into the book ColdFusion Functions by Michael Dinowitz (published by Fusion Authority). All rights reserved. An explanation of what each data type is can be found here
NAMEATTRIBUTESDATATYPEGROUPVERSION
ABS(number)NumericMathematical2.0
ACOS(number)NumericMathematical4.01
ARRAYAPPEND(array, value)BooleanArray, Exec3.0
ARRAYAVG(array)NumericArray3.1
ARRAYCLEAR(array)BooleanArray, Exec3.0
ARRAYDELETEAT(array, position)BooleanArray, Exec3.0
ARRAYINSERTAT(array, position)BooleanArray, Exec3.0
ARRAYISEMPTY(array)BooleanArray3.0
ARRAYLEN(array)NumericArray3.0
ARRAYMAX(array)NumericArray3.1
ARRAYMIN(array)NumericArray3.1
ARRAYNEW(dimension)ArrayArray3.0
ARRAYPREPEND(array, value)BooleanArray3.0
ARRAYRESIZE(array, minimum_size)BooleanArray3.0
ARRAYSET(array, start_pos, end_pos, value)BooleanArray3.0
ARRAYSORT(array, sort_type [, sort_order ])ArrayArray3.1
ARRAYSUM(array)NumericArray3.1
ARRAYSWAP(array, position1, position2)BooleanArray3.0
ARRAYTOLIST(array [, delimiter ])ListArray, List3.1
ASC(string)NumericMathematical,string2.0
ASIN(number)NumericMathematical4.01
ATN(number)NumericMathematical2.0
AUTHENTICATEDCONTEXT( )StringAuthentication4.01
AUTHENTICATEDUSER( )StringAuthentication4.01
BITAND(number1, number2)NumericBit, Mathematical2.0
BITMASKCLEAR(number, start, length)NumericBit, Mathematical2.0
BITMASKREAD(number, start, length)NumericBit, Mathematical2.0
BITMASKSET(number, mask, start, length)NumericBit, Mathematical2.0
BITNOT(number)NumericBit, Mathematical2.0
BITOR(number1, number2)NumericBit, Mathematical2.0
BITSHLN(number, count)NumericBit, Mathematical2.0
BITSHRN(number, count)NumericBit, Mathematical2.0
BITXOR(number1, number2)NumericBit, Mathematical2.0
CEILING(number)NumericMathematical2.0
CF_GETDATASOURCEUSERNAME(Data Source)StringSystem3.0*
CF_ISCOLDFUSIONDATASOURCE(Data Source)BooleanDecision3.0*
CF_SETDATASOURCEPASSWORD(Data Source, Password)BooleanSystem, Exec3.0*
CF_SETDATASOURCEUSERNAME(Data Source, Username)BooleanSystem, Exec3.0*
CFUSION_DBCONNECTIONS_FLUSH( )NULLSystem, Exec3.0*
CFUSION_DECRYPT(cyphertext, key)StringCrypto3.0*
CFUSION_DISABLE_DBCONNECTIONS(DataSource, switch)BooleanSystem, Exec3.0*
CFUSION_ENCRYPT(text, key)StringCrypto3.0*
CFUSION_GETODBCDSN( )QuerySystem3.0*
CFUSION_GETODBCINI(section, entry, default value)StringSystem3.0*
CFUSION_SETODBCINI(section, entry, value)BooleanSystem, Exec3.0*
CFUSION_SETTINGS_REFRESH( )NULLSystem, Exec3.0*
CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout)StringSystem3.0*
CHR(number)StringString2.0
CJUSTIFY(string, length)StringString2.0
COMPARE(string1, string2)NumericString2.0
COMPARENOCASE(string1, string2)NumericString2.0
COS(number)NumericMathematical2.0
CREATEDATE(year, month, day)DateDate/Time2.0
CREATEDATETIME(year, month, day, hour, minute, second)Date/TimeDate/Time2.0
CREATEOBJECT("COM", class, context, serverName)ObjectObject4.5
CREATEOBJECT("CORBA", class, context, locale)ObjectObject4.5
CREATEOBJECT("JAVA", class)ObjectObject4.5
CREATEODBCDATE(date)DateDate/Time2.0
CREATEODBCDATETIME(date)Date/TimeDate/Time2.0
CREATEODBCTIME(date)TimeDate/Time2.0
CREATETIME(hour, minute, second)TimeDate/Time2.0
CREATETIMESPAN(days, hours, minutes, seconds)Date/TimeDate/Time2.0
CREATEUUID( )UUID StringOther4.01
DATEADD(datepart, number, date)Date/TimeDate/Time2.0
DATECOMPARE(date1, date2)NumericDate/Time2.0
DATECONVERT(conversion_type, date)Date/TimeDate/Time4.01
DATEDIFF(datepart, date1, date2)NumericDate/Time2.0
DATEFORMAT(date [, mask ])DateDate/Time1.0
DATEPART(datepart, date)NumericDate/Time2.0
DAY(date)NumericDate/Time2.0
DAYOFWEEK(date)NumericDate/Time2.0
DAYOFWEEKASSTRING(day_of_week)StringDate/Time,string2.0
DAYOFYEAR(date)NumericDate/Time2.0
DAYSINMONTH(date)NumericDate/Time2.0
DAYSINYEAR(date)NumericDate/Time2.0
DE(string)Escaped StringDynamic Evaluation2.0
DECIMALFORMAT(number)NumericDisplay/Formatting1.0
DECREMENTVALUE(number)NumericMathematical1.5
DECRYPT(encrypted_string, key)StringCrypto4.0
DELETECLIENTVARIABLE(name)BooleanSystem, Exec2.0
DIRECTORYEXISTS(absolute_path)BooleanSystem4.0
DOLLARFORMAT(number)StringDisplay/Formatting1.0
DUPLICATE(variable_name)Complex DataTypeDynamic Evaluation4.5.1
ENCRYPT(string, key)StringCrypto4.0
EVALUATE(string_expression1 [, string_expression2 [, … ] ])Evaluated DataDynamic Evaluation2.0
EXP(number)NumericMathematical2.0
EXPANDPATH(relative_path)StringSystem2.0
FILEEXISTS(absolute_path)BooleanSystem2.0
FIND(substring, string [, start ])NumericString2.0
FINDNOCASE(substring, string [, start ])NumericString2.0
FINDONEOF(set, string [, start ])NumericString2.0
FIRSTDAYOFMONTH(date)NumericDate/Time2.0
FIX(number)NumericMathematical2.0
FORMATBASEN(number, radix)StringMathematical2.0
GETBASETAGDATA(tagname [, instancenumber ])StructureCustom Tag4.0
GETBASETAGLIST( )ListCustom Tag4.0
GETBASETEMPLATEPATH( )StringSystem4.01
GETCLIENTVARIABLESLIST( )ListOther2.0
GETCURRENTTEMPLATEPATH( )StringSystem4.01
GETDIRECTORYFROMPATH(path)StringSystem2.0
GETFILEFROMPATH(path)StringSystem2.0
GETFUNCTIONLIST( )StructureOther4.5
GETHTTPREQUESTDATA( )StructureOther5.0
GETHTTPTIMESTRING(date)StringDisplay/Formatting4.5
GETLOCALE( )String*International3.1
GETMETRICDATA(monitor_name)StructureSystem4.5
GETPROFILESTRING(iniPath, section, entry)StringSystem4.01
GETTEMPDIRECTORY( )StringSystem2.0
GETTEMPFILE(dir, prefix)StringSystem2.0
GETTEMPLATEPATH( )StringSystem2.0
GETTICKCOUNT( )NumericOther4.0
GETTIMEZONEINFO( )StructureSystem4.01
GETTOKEN(string, index [, delimiters ])StringString2.0
HASH(string)StringCrypto4.5
HOUR(Date)NumericDate/Time2.0
HTMLCODEFORMAT(string [, version ])StringDisplay/Formatting1.0
HTMLEDITFORMAT(string [, version ])StringDisplay/Formatting1.5
IIF(condition, string_expression1, string_expression2)String*Dynamic Evaluation2.0
INCREMENTVALUE(number)NumericMathematical1.5
INPUTBASEN(string, radix)NumericMathematical2.0
INSERT(substring, string, position)StringString2.0
INT(number)NumericMathematical2.0
ISARRAY(value [, number ])BooleanDecision3.0
ISAUTHENTICATED([security context name])BooleanDecision, Authentication4.0
ISAUTHORIZED(resourcetype, resourcename [, action ])BooleanDecision, Authentication4.0
ISBINARY(value)BooleanDecision4.5
ISBOOLEAN(value)BooleanDecision2.0
ISDATE(string)BooleanDecision2.0
ISDEBUGMODE( )BooleanDecision4.0
ISDEFINED('variable')*BooleanDecision3.0
ISLEAPYEAR(year)BooleanDecision2.0
ISNUMERIC(string)BooleanDecision2.0
ISNUMERICDATE(number)BooleanDecision2.0
ISPROTECTED(resourcetype, resourcename [, action])BooleanDecision4.5
ISQUERY(value)BooleanDecision3.0
ISSIMPLEVALUE(value)BooleanDecision3.0
ISSTRUCT(variable)BooleanDecision4.0
ISWDDX(value)BooleanDecision4.51sp2
JAVACAST(type, variable)*Other4.5
JSSTRINGFORMAT(string)StringDisplay/Formatting4.5
LCASE(string)StringString2.0
LEFT(string, count)StringString2.0
LEN(string)NumericString2.0
LISTAPPEND(list, value [, delimiters ])ListList2.0
LISTCHANGEDELIMS(list, new_delimiter [, delimiters ])ListList2.0
LISTCONTAINS(list, substring [, delimiters ])NumericList2.0
LISTCONTAINSNOCASE(list, substring [, delimiters ])NumericList2.0
LISTDELETEAT(list, position [, delimiters ])ListList2.0
LISTFIND(list, value [, delimiters ])NumericList2.0
LISTFINDNOCASE(list, value [, delimiters ])NumericList2.0
LISTFIRST(list [, delimiters ])StringList2.0
LISTGETAT(list, position [, delimiters ])StringList2.0
LISTINSERTAT(list, position, value [, delimiters ])ListList2.0
LISTLAST(list [, delimiters ])StringList2.0
LISTLEN(list [, delimiters ])NumericList2.0
LISTPREPEND(list, value [, delimiters ])ListList2.0
LISTQUALIFY(list, qualifier [, delimiters ] [, elements ])ListList4.01
LISTREST(list [, delimiters ])ListList2.0
LISTSETAT(list, position, value [, delimiters ])ListList2.0
LISTSORT(list, sort_type [, sort_order] [, delimiters ])ListList4.01
LISTTOARRAY(list [, delimiter ])ArrayList, Array3.1
LISTVALUECOUNT(list, value [, delimiter ])NumericList4.01
LISTVALUECOUNTNOCASE(list, value [, delimiter ])NumericList4.01
LJUSTIFY(string, length)StringString2.0
LOG(number)NumericMathematical2.0
LOG10(number)NumericMathematical2.0
LSCURRENCYFORMAT(number [, type])StringInternational, Display/Formatting3.1
LSDATEFORMAT(date [, mask])String*International, Display/Formatting3.1
LSEUROCURRENCYFORMAT(currency_number [, type])StringInternational, Display/Formatting4.01
LSISCURRENCY(string)BooleanInternational, Decision3.1
LSISDATE(string)BooleanInternational, Decision3.1
LSISNUMERIC(string)BooleanInternational, Decision3.1
LSNUMBERFORMAT(number [, mask])String*International, Display/Formatting3.1
LSPARSECURRENCY(string)StringInternational3.1
LSPARSEDATETIME(string)String*International3.1
LSPARSEEUROCURRENCY(currency_string)StringInternational4.01
LSPARSENUMBER(string)StringInternational3.1
LSTIMEFORMAT(time [, mask])StringInternational, Display/Formatting3.1
LTRIM(string)StringString2.0
MAX(number1, number2)NumericMathematical2.0
MID(string, start, count)StringString2.0
MIN(number1, number2)NumericMathematical2.0
MINUTE(date)NumericDate/Time2.0
MONTH(Date)NumericDate/Time2.0
MONTHASSTRING(month number)StringDate/Time,string2.0
NOW( )Date/TimeDate/Time2.0
NUMBERFORMAT(number [, mask ])NumericDisplay/Formatting1.0
PARAGRAPHFORMAT(string)StringDisplay/Formatting1.0
PARAMETEREXISTS(parameter)BooleanDecision1.5
PARSEDATETIME(string1 [, string2])Date/TimeDate/Time2.0
PI( )NumericMathematical2.0
PRESERVESINGLEQUOTES(string)StringString1.5
QUARTER(date)Numeric_2.0
QUERYADDCOLUMN(query, column_name, array_name)QueryQuery4.01
QUERYADDROW(query [, number ])NumericQuery3.0
QUERYNEW(columnlist)QueryQuery3.0
QUERYSETCELL(query, column_name, value [, row_number])BooleanQuery3.0
QUOTEDVALUELIST(query.column [, delimiter ])ListQuery, List1.5
RAND( )NumericMathematical2.0
RANDOMIZE(number)NumericMathematical2.0
RANDRANGE(number1, number2)NumericMathematical2.0
REFIND(reg_expression, string, start)*Regular Expressions2.0
REFINDNOCASE(reg_expression, string [, start ] [, returnsubexpressions ])*Regular Expressions4.0
REMOVECHARS(string, start, count)StringString2.0
REPEATSTRING(string, count)StringString2.0
REPLACE(string, substring1, substring2 [, scope ])StringString2.0
REPLACELIST(string, list1, list2)StringString2.0
REPLACENOCASE(string substring1, substring2 [, scope ])StringString3.0
REREPLACE(string, reg_expression, substring [, scope ])StringRegular Expressions2.0
REREPLACENOCASE(string, reg_expression, substring [, scope ])StringRegular Expressions4.0
REVERSE(string)StringString2.0
RIGHT(string, count)StringString2.0
RJUSTIFY(string, length)StringString2.0
ROUND(number)NumericMathematical2.0
RTRIM(string)NumericString2.0
SECOND(date)Numeric_2.0
SETLOCALE(new_locale)*International3.1
SETPROFILESTRING(iniPath, section, entry, value)NULL*_4.01
SETVARIABLE(name, value)*Dynamic Evaluation2.0
SGN(number)NumericMathematical2.0
SIN(number)NumericMathematical2.0
SPANEXCLUDING(string, set)StringString2.0
SPANINCLUDING(string, set)StringString2.0
SQR(number)NumericMathematical2.0
STRIPCR(string)StringDisplay/Formatting1.0
STRUCTAPPEND(Struct1, Struct2 [, OverwriteFlag])BooleanStructure, Exec4.51sp2
STRUCTCLEAR(structure)BooleanStructure, Exec4.0
STRUCTCOPY(structure)StructureStructure4.0
STRUCTCOUNT(structure)NumericStructure4.0
STRUCTDELETE(structure, key [, indicatenotexisting ])BooleanStructure, Exec4.0
STRUCTFIND(structure, key)StringStructure4.0
STRUCTFINDKEY(Top, Key [, Scope])ArrayStructure4.51sp2
STRUCTFINDVALUE(Top, Key [, Scope])ArrayStructure4.51sp2
STRUCTGET(PathDesired)*Structure4.51sp2
STRUCTINSERT(structure, key, value [, allowoverwrite ])BooleanStructure, Exec4.0
STRUCTISEMPTY(structure)BooleanStructure4.0
STRUCTKEYARRAY(structure)ArrayStructure4.01
STRUCTKEYEXISTS(structure, key)BooleanStructure4.0
STRUCTKEYLIST(structure, [delimiter])ListStructure4.01
STRUCTNEW( )StructureStructure4.0
STRUCTSORT(Base [, SortType, SortOrder, PathToSubElement])ArrayStructure4.51sp2
STRUCTUPDATE(structure, key, value)BooleanStructure4.0
TAN(number)NumericMathematical2.0
TIMEFORMAT(time [, mask ])Date/TimeDisplay/Formatting1.0
TOBASE64(string or binary_object)StringCrypto4.5
TOBINARY(string_in_Base64 or binary_value)*Crypto4.5
TOSTRING(any_value)StringDisplay/Formatting4.5
TRIM(string)StringString2.0
UCASE(string)StringString2.0
URLDECODE(urlEncodedString)StringCrypto4.5
URLENCODEDFORMAT(string)StringCrypto1.5
VAL(string)NumericString2.0
VALUELIST(query.column [, delimiter ])ListQuery, List1.5
WEEK(date)NumericDate/Time2.0
WRITEOUTPUT(string)*Dynamic Evaluation4.0
XMLFORMAT(string)StringDisplay/Formatting4.5
YEAR(date)NumericDate/Time2.0
YESNOFORMAT(value)StringDisplay/Formatting1.0