background image

24

Quick Reference to CFML

CFQUERY and CFSTOREDPROC variables

In addition to returning data from a ColdFusion data source, 
the CFQUERY tag also returns information about the query:

CFQUERY.ExecutionTime 

CFQUERY also uses the name of the query to scope data 
about the query:

queryname

.CurrentRow

queryname

.RecordCount

queryname

.ColumnList

The CFSTOREDPROC tag also returns:

CFSTOREDPROC.ExecutionTime
CFSTOREDPROC.StatusCode

CFREGISTRY variables

The CFREGISTRY tag returns a query record set that  you can 
reference after executing the GetAll action. Queryname is 
the value of the NAME attribute used in the CFREGISTRY 
operation.

queryname

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

searchname

.URL

searchname

.Key

searchname

.Title

searchname

.Score

searchname

.Custom1 and Custom2

searchname

.Summary

searchname

.RecordCount

searchname

.CurrentRow

searchname

.RecordsSearched

searchname

.ColumnList

CFSERVLET variables

If the WRITEOUTPUT attribute is NO, CFSERVLET returns the 
text output of the servlet in the following variable: 

CFSERVLET.Output

If the servlet returns any response headers, they are in the 
CFSERVLET return structure. Each response header can be 
accessed through a key. In the following syntax, servletRe-
sponseHeader 
is a key, which is the name of the response 
header set in the servlet: 

CFSERVLET.

servletResponseHeader

Содержание COLDFUSION 4.5- TO CFML

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 16: ...LCodeFormat string version HTMLEditFormat string version LSCurrencyFormat number type LSDateFormat date mask LSEuroCurrencyFormat currency number type LSNumberFormat number mask LSTimeFormat time mask...

Страница 17: ...istSort list sort_type sort_order delimiter ListToArray list delimiter ListValueCount list value delimiters ListValueCountNoCase list value delimiters International functions DateConvert conversion ty...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 25: ...written CFFILE FileWasRenamed CFFILE FileWasSaved CFFILE OldFileSize CFFILE ServerDirectory CFFILE ServerFile CFFILE ServerFileExt CFFILE ServerFileName CFFILE TimeCreated CFFILE TimeLastModified CFFT...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 33: ...30 Quick Reference to CFML...

Отзывы: