MACROMEDIA COLFUSION MX 7-CFML Quick Reference

Other manuals for COLFUSION MX 7-CFML: Reference

Summary of COLFUSION MX 7-CFML

  • Page 1

    Coldfusion ® mx 7 cfml quick reference.

  • Page 2

    Trademarks 1 step robopdf, activeedit, activetest, authorware, blue sky software, blue sky, breeze, breezo, captivate, central, coldfusion, contribute, database explorer, director, dreamweaver, fireworks, flash, flashcast, flashhelp, flash lite, flashpaper, flex, flex builder, fontographer, freehand...

  • Page 3: Contents

    Cfml quick reference 3 contents cfml tags . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 cfml functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 array functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 convers...

  • Page 4

    4 cfml quick reference cfpop variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 cfquery and cfstoredproc variables . . . . . . . . . 37 cfregistry variables . . . . . . . . . . . . . . . . . . . . . . . . . . 37 cfsearch variables . . . . . . . . . . . . . . . . . . . . . . ....

  • Page 5

    Cfml quick reference 5 cfml tags cfabort showerror = "error_message"> 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 = "alignment_option" ...

  • Page 6

    6 cfml quick reference cfcase value = "value or delimited set of values" delimiters = "delimiter characters"> cfcatch exception processing code here cfchart syntax 1 style = "xml string or filename"> syntax 2 backgroundcolor = "hex value or web color" chartheight = "integer number of pixels" chartwi...

  • Page 7

    Cfml quick reference 7 cfcollection action = "action" collection = "collection_name" path = "path_to_verity_collection" language = "language" name = "queryname" categories = "yes" or "no"> cfcomponent extends ="anothercomponent" output = "yes" or "no" style = "rpc" or "document" namespace = "default...

  • Page 8

    8 cfml quick reference html and cfml code cfdocumentitem syntax 1 syntax 2 type = "header" or "footer"> header/footer text type = "header" or "footer"> header/footer text cfdocumentsection margintop = "number" marginbottom = "number" marginleft = "number" marginright = "number"> html, cfml, and cfdo...

  • Page 9

    Cfml quick reference 9 action = "copy" source = "full_path_name" destination = "full_path_name" mode = "mode" attributes = "file_attributes_list"> action = "delete" file = "full_path_name"> action = "move" source = "full_path_name" destination = "full_path_name" mode = "mode" attributes = "file_attr...

  • Page 10

    10 cfml quick reference the following attributes are supported in html and xml only class = "form class" enctype = "internet media type" id = "html id" onload = "load event script" onreset = "reset event script" target = "target window or frame"> ... Cfformgroup type = "group type" label = "label" s...

  • Page 11

    Cfml quick reference 11 new = "file or directory name" proxyserver = "proxy server" passive = "yes" or "no"> result = "result_name" cfftp action = "listdir" action = "listdir" action = "listdir" cffunction name = "methodname" returntype = "datatype" roles = "securityroles" access = "methodaccess" de...

  • Page 12

    12 cfml quick reference sortdescendingbutton = "text"> zero or more cfgridcolumn and cfgridrow tags cfgridcolumn name = "column_name" header = "header" width = "column_width" type = "type" display = "yes" or "no" select = "yes" or "no" font = "column_font" fontsize = "size" italic = "yes" or "no" bo...

  • Page 13

    Cfml quick reference 13 multipart = "yes or no" path = "path" file = "filename" name = "queryname" columns = "query_columns" firstrowasheaders = "yes" or "no" delimiter = "character" textqualifier = "character" result = "result_name" cfhttpparam tags [optional for some methods] cfhttpparam type = "t...

  • Page 14

    14 cfml quick reference onkeydown = "javascript or actionscript" onmouseup = "javascript or actionscript" onmousedown = "javascript or actionscript" onchange = "javascript or actionscript" onclick = "javascript or actionscript" firstdayofweek = "day name" daynames = "days-of-the-week labels" monthna...

  • Page 15

    Cfml quick reference 15 syntax 4b webservice = "web service name" name = "mystringname for instantiated object" method = "operation_name"> webservice = "#my stringname for instantiated web service#" timeout = "request timeout in seconds" proxyserver = "wsdl proxy server url proxyport = "numeric port...

  • Page 16

    16 cfml quick reference password = "password-string" roles = "roles"> ...> cfloginuser name = "name" password = "password-string" roles = "roles"> cflogout cfloop cfloop: index loop index = "parameter_name" from = "beginning_value" to = "ending_value" step = "increment"> html or cfml code cfloop: co...

  • Page 17

    Cfml quick reference 17 (optional) mail message body and/or cfhttpparam tags cfmailparam to = "recipient" subject = "msg_subject" from = "sender" ...More attributes... > file = "file-name" type ="media type" contentid = "content id" disposition = "disposition type"> or name = "header-name" value = "...

  • Page 18

    18 cfml quick reference cfobject: web service object webservice= "http://....?Wsdl" or "name set in administrator" name = "myobjectname"> cfobjectcache action = "clear"> cfoutput query = "query_name" group = "query_column" groupcasesensitive = "yes" or "no" startrow = "start_row" maxrows = "max_rows...

  • Page 19

    Cfml quick reference 19 username = "username" password = "password" maxrows = "number" blockfactor = "blocksize" timeout = "seconds" cachedafter = "date" cachedwithin = "timespan" either of the following: debug = "yes" or "no" or debug > result = "result_name" cfqueryparam name = "query_name" dataso...

  • Page 20

    20 cfml quick reference syntax 2 report = "report_path" datasource = "ds_name" type = "type" timeout = "number of seconds" orderby = "result_order" username = "username" password = "password" formula = "formula"> report = "report_path" datasource = "ds_name" type = "type" timeout = "number of second...

  • Page 21

    Cfml quick reference 21 previouscriteria = "criteria" language = "language"> cfselect name = "name" label = "label" style = "style specification" size = "integer" required = "yes" or "no" message = "text" onerror = "text" multiple = "yes" or "no" query = "queryname" value = "text" display = "text"> ...

  • Page 22

    22 cfml quick reference cfswitch expression = "expression"> one or more cfcase tags zero or one cfdefaultcase tags expression = "expression"> one or more cfcase tags zero or one cfdefaultcase tags cftable query = "query_name" maxrows = "maxrows_table" colspacing = "number_of_spaces" headerlines = "n...

  • Page 23

    Cfml quick reference 23 cftransaction action = "begin" or "commit" or "rollback" isolation = "read_uncommitted" or "read_committed" or "repeatable_read" > action = "begin" or "commit" or "rollback" isolation = "read_uncommitted" or "read_committed" or "repeatable_read" > cftree format="applet", "fla...

  • Page 24

    24 cfml quick reference 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...

  • Page 25

    Cfml quick reference 25 dayofweek(" date ") dayofweekasstring( day_of_week ) dayofyear(" date ") daysinmonth(" date ") daysinyear(" date ") firstdayofmonth( date ) gethttptimestring( date_time_object ) gettickcount() gettimezoneinfo() hour( date ) isdate( string ) isleapyear( year ) isnumericdate( n...

  • Page 26

    26 cfml quick reference isxmlnode( value ) isxmlroot( value ) lsiscurrency( string ) lsisdate( string ) lsisnumeric( string ) structisempty( structure ) structkeyexists( structure , " key ") yesnoformat( value ) display and formatting functions cjustify( string , length ) dateformat(" date " [, " ma...

  • Page 27

    Cfml quick reference 27 international functions dateconvert(" conversion-type ", " date ") getencoding( scope_name ) gethttptimestring( date_time_object ) getlocale() getlocaledisplayname([ locale [, inlocale ]]) gettimezoneinfo() lscurrencyformat( number [, type ]) lsdateformat( date [, mask ]) lse...

  • Page 28

    28 cfml quick reference listvaluecount( list, value [, delimiters ]) listvaluecountnocase( list, value [, delimiters ]) replacelist( string , list1 , list2 ) mathematical functions abs ( number ) acos( number ) arrayavg( array ) arraysum( array ) asin( number ) atn( number ) bitand( number1 , number...

  • Page 29

    Cfml quick reference 29 querysetcell( query , column_name , value [, row_number ]) quotedvaluelist( query.Column [, delimiter ]) valuelist( query.Column [, delimiter ]) security functions decrypt( encrypted_string , key [, algorithm [, encoding ]]) encrypt( string , key [, algorithm [, encoding ]]) ...

  • Page 30

    30 cfml quick reference lsparseeurocurrency( currency-string ) lsparsenumber( string ) ltrim( string ) mid( string , start , count ) monthasstring( month_number ) paragraphformat( string ) parsedatetime( date/time-string [, pop-conversion ]) refind( reg_expression , string [, start ] [, returnsubexp...

  • Page 31

    Cfml quick reference 31 system functions directoryexists( absolute_path ) duplicate( variable_name ) expandpath( relative_path ) fileexists( absolute_path ) getbasetemplatepath() getcontextroot() getcurrenttemplatepath() getdirectoryfrompath( path ) getencoding( scope_name ) getexception( object ) g...

  • Page 32

    32 cfml quick reference gateway interface methods to implement gatewayname([string id [, string configfile ]]) string getgatewayid() gatewayhelper gethelper() int getstatus() string outgoingmessage(coldfusion. Eventgateway.Cfevent cfmessage) void restart() void setcfclisteners(string[] listeners) vo...

  • Page 33

    Cfml quick reference 33 caller scope coldfusion mx supports the caller scope as a structure. Client variables the following client variables are reserved: client.Cfid client.Cftoken client.Hitcount client.Lastvisit client.Timecreated client.Urltoken server variables use the server prefix to referenc...

  • Page 34

    34 cfml quick reference field_name3 = "value"> ... Each nested tag can access the variable with the cfoutput tag, as follows: #request.Field_name1# form variable coldfusion supports the form variable fieldnames. Fieldnames returns the names of the fields on a form. You use it on the action page asso...

  • Page 35

    Cfml quick reference 35 cfcatch.Column cfcatch.Knowncolumn cfcatch.Line cfcatch.Knownline cfdirectory variables the cfdirectory tag, with action=list , returns a query object as follows, where queryname is the name attribute value: queryname.Name queryname.Size queryname.Type queryname.Datelastmodif...

  • Page 36

    36 cfml quick reference cffile.Serverfileext cffile.Serverfilename cffile.Timecreated cffile.Timelastmodified cfftp error variables when you use the cfftp stoponerror attribute, these variables are populated: cfftp.Succeeded cfftp.Errorcode cfftp.Errortext cfftp returnvalue variable some cfftp file ...

  • Page 37

    Cfml quick reference 37 queryname .Columnlist queryname .Attachments queryname .Attachmentfiles cfquery and cfstoredproc variables the cfquery tag returns information about the query in this variable: cfquery.Executiontime the cfquery tag uses the query name to scope the following data about the que...

  • Page 38

    38 cfml quick reference client cgi.Cert_issuer cgi.Cert_subject cgi.Client_cert_encoded cgi.Http_accept cgi.Http_if_modified_since cgi.Http_user_agent the cert_issuer, cert_subject , client_cert_encoded variables are available only when you use client certificates. Cgi environment variables when a b...