MACROMEDIA COLDFUSION 5-CFML Manuale utente

Macromedia® Incorporated

CFML Quick Reference

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

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

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

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

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

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"

URL = "URL string"

URLColumn = "query column"

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

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

<cfheader

statusCode = "status_code"

statusText = "status_text">

cfhtmlhead

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

HTML and CFML tags

HTML and CFML tags

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

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

Altri manuali per COLDFUSION 5-CFML

Questo manuale è adatto per i seguenti modelli

Indice

Altri manuali MACROMEDIA Software

MACROMEDIA

MACROMEDIA BREEZE-USING THE MACROMEDIA BREEZE MANAGER Istruzioni per il montaggio

MACROMEDIA

MACROMEDIA FLASH MEDIA SERVER 2-SERVER MANAGEMENT ACTIONSCRIPT... Manuale di servizio

MACROMEDIA

MACROMEDIA DIRECTOR MX 2004-USING DIRECTOR Istruzioni per il montaggio

MACROMEDIA

MACROMEDIA DIRECTOR MX-LINGO DICTIONARY Manuale utente

MACROMEDIA

MACROMEDIA COLDFUSION MX 61-CFML Manuale di servizio

MACROMEDIA

MACROMEDIA 38028779 - Macromedia Dreamweaver - Mac Istruzioni per l'installazione e il funzionamento

MACROMEDIA

MACROMEDIA COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION... Manuale utente

MACROMEDIA

MACROMEDIA DRUMBEAT 2000 ECOMMERCE EDITION Manuale utente

MACROMEDIA

MACROMEDIA BREEZE-MANAGING EXTERNAL BREEZE REPORTS Manuale utente

MACROMEDIA

MACROMEDIA FREEHAND 10-USING FREEHAND Istruzioni per il montaggio

MACROMEDIA

MACROMEDIA FLASH MEDIA SERVER 2-DEVELOPING MEDIA Manuale utente

MACROMEDIA

MACROMEDIA BREEZE-SECURITY Manuale utente

MACROMEDIA

MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION Manuale utente

MACROMEDIA

MACROMEDIA FLEX-FLEX BUILDER Istruzioni operative

MACROMEDIA

MACROMEDIA FLASH 8-DEVELOPING FLASH LITE 2.X Manuale utente

MACROMEDIA

MACROMEDIA FLASH 8-FLASH Manuale di servizio

MACROMEDIA

MACROMEDIA DIRECTOR MX 2004-USING DIRECTOR Istruzioni per il montaggio

MACROMEDIA

MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX Manuale utente

MACROMEDIA

MACROMEDIA COLDFUSION MX 61 - CONFIGURING AND ADMINISTERING COLDFUSION... Manuale utente

MACROMEDIA

MACROMEDIA BREEZE 5 Manuale dell'operatore

MACROMEDIA

MACROMEDIA BREEZE-USING THE BREEZE XML WEB SERVICES Istruzioni per il montaggio

MACROMEDIA

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING... Manuale utente

MACROMEDIA

MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION... Manuale utente

MACROMEDIA

MACROMEDIA DIRECTOR MX-USING DIRECTOR MX Istruzioni per il montaggio

Manuali Software popolari di altre marche

COMPRO

COMPRO COMPROFM Manuale utente

Muratec

Muratec OFFICEBRIDGE ONLINE Manuale utente

Oracle

Oracle Contact Center Anywhere 8.1 Manuale utente

Adobe

Adobe 65007312 - Photoshop Lightroom Manuale

Avaya

Avaya NULL One-X for RIM Blackberry Manuale utente

HP ProLiant BL420c Manuale utente

PS Audio

PS Audio PowerPlay Manuale del proprietario

Brady

Brady LOCKOUT PRO 3.0 Manuale di servizio

Avaya

Avaya Interaction Center Manuale utente

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Manuale

Novell

Novell GROUPWISE 8 - INTERNET AGENT Manuale utente

Oracle

Oracle Application 9i Manuale utente

Acer

Acer RDM Manuale utente

Canon

Canon Vixia HF21 Manuale utente

Canon

Canon ZR950 Manuale utente

Samsung

Samsung Auto Backup Manuale utente

Polycom

Polycom Vortex EF2201 Istruzioni per l'installazione e il funzionamento

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Manuale utente