background image

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

Summary of Contents for COLDFUSION 4.5- TO CFML

Page 1: ...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 Alla...

Page 2: ...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 S...

Page 3: ...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...

Page 4: ...ATE BASETAG tagname DATACOLLECTION collectionname CFAUTHENTICATE CFAUTHENTICATE SECURITYCONTEXT context USERNAME user ID PASSWORD password SETCOOKIE Yes or No THROWONFAILURE Yes or No CFBREAK CFBREAK...

Page 5: ...ION 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...

Page 6: ...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 ONVALIDA...

Page 7: ...IFIER 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...

Page 8: ...R 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 ow...

Page 9: ...um 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 MI...

Page 10: ...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 TIMEOU...

Page 11: ...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 ACTIO...

Page 12: ...Yes or No CFSERVLETPARAM NAME parameter name VALUE value CFSERVLET CFSERVLETPARAM CFSERVLET CFSERVLETPARAM NAME servlet parameter name VALUE servlet parameter value CFSERVLETPARAM NAME servlet attribu...

Page 13: ...TABLE 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 V...

Page 14: ...T 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...

Page 15: ...and time functions CreateDate year month day CreateDateTime year month day hour minute second CreateODBCDate date CreateODBCDateTime date CreateODBCTime date CreateTime hour minute second CreateTimeS...

Page 16: ...LCodeFormat string version HTMLEditFormat string version LSCurrencyFormat number type LSDateFormat date mask LSEuroCurrencyFormat currency number type LSNumberFormat number mask LSTimeFormat time mask...

Page 17: ...istSort list sort_type sort_order delimiter ListToArray list delimiter ListValueCount list value delimiters ListValueCountNoCase list value delimiters International functions DateConvert conversion ty...

Page 18: ...ist 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 Fi...

Page 19: ...ng any_value Trim string UCase string Val string XMLFormat string Structure functions IsStruct variable StructClear structure StructCopy structure StructCount structure StructDelete structure key indi...

Page 20: ...or naming_service int_orb_args CreateObject JAVA classname CreateUUID Decrypt encrypted_string key DeleteClientVariable name Encrypt string key GetBaseTagData tagname instancenumber GetBaseTagList Ge...

Page 21: ...HitCount Client LastVisit Client TimeCreated Client URLToken Server variables Use the Server prefix to reference server variables Server ColdFusion ProductName Server ColdFusion ProductVersion Server...

Page 22: ...s store data that pertains to the processing of a single page request Request variables allow you to store data in a structure that can be passed to nested tags such as Custom Tags and processed once...

Page 23: ...VLET CFSTOREDPROC ColdFusion query variables Any ColdFusion tag that returns a query object supports the following variables queryname CurrentRow queryname RecordCount queryname ColumnList Where query...

Page 24: ...GeneratedContent Error RemoteAddress Error HTTPReferer Error Template Error QueryString The following error variables are available if you have speci fied TYPE Validation Error ValidationHeader Error...

Page 25: ...written CFFILE FileWasRenamed CFFILE FileWasSaved CFFILE OldFileSize CFFILE ServerDirectory CFFILE ServerFile CFFILE ServerFileExt CFFILE ServerFileName CFFILE TimeCreated CFFILE TimeLastModified CFFT...

Page 26: ...le depending on the MIME type CFHTTP FileContent CFHTTP MimeType CFHTTP Header CFHTTP ResponseHeader http_hd_key CFHTTP StatusCode CFLDAP variables CFLDAP returns information about the LDAP query if A...

Page 27: ...Entry queryname Type queryname Value CFSEARCH variables Every CFSEARCH operation returns the following variables Searchname is the value of the NAME attribute used in the CFSEARCH operation searchnam...

Page 28: ...CGI CONTENT_LENGTH CGI CONTENT_TYPE CGI PATH_INFO CGI PATH_TRANSLATED CGI QUERY_STRING CGI REMOTE_ADDR CGI REMOTE_HOST CGI REMOTE_USER CGI REQUEST_METHOD CGI SCRIPT_NAME Server CGI GATEWAY_INTERFACE...

Page 29: ...Shortcuts File and Document Shortcuts Command Key File Open Ctrl O File Save Ctrl S File Save As Shift Ctrl S File Close Ctrl W File Close All Shift Ctrl W File Print Ctrl P Open default template CTRL...

Page 30: ...Ctrl E Tools Spell Check F7 Tools Spell Check All Shift F7 Tools Mark Spelling Errors Ctrl F7 Tools Validate Document Shift F6 Tools Validate Current Tag F6 Open Development Mappings dialog Alt M Ope...

Page 31: ...nt tag Esc to close F2 Tags Edit Current Tag Ctrl F4 Tags Inspect Current Tag F4 Insert Underline tag Ctrl U Insert pound sign CTRL 3 View Full Screen F10 View QuickBar Ctrl H View Resources Tab F9 Vi...

Page 32: ...Start Continue Ctrl F5 Start No debugging Ctrl Alt F5 End Alt F5 Restart Ctrl Shift F5 Step Into Ctrl F8 Step Over Ctrl F9 Run To Cursor Ctrl F11 Variables Alt Q Watches Alt W Recordsets Alt R Stack A...

Page 33: ...30 Quick Reference to CFML...

Reviews: