manualshive.com logo in svg

MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Справочник

Поделиться
Скачать
MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE Скачать руководство пользователя страница 505

Chapter 2:  ColdFusion Functions

481

QueryAddColumn

Adds a new column to a specified query and populates the column’s rows with the 
contents of a one-dimensional array. Returns the query object with the additional 
column. Padding is added, if necessary, on the query columns to ensure that all 
columns have the same number of rows.

See also 

CFQUERY

, 

QueryNew

, 

QueryAddRow

 and 

QuerySetCell

.

Syntax

QueryAddColumn

(

query, column-name, array-name)

query

Name of a query that was created with QueryNew.

column-name

The name of the new column.

array-name

The name of the array whose elements are to populate the new column.

Usage

You can add columns to any type of query object, such as queries retrieved with 
CFQUERY or queries created with QueryNew. The only type of query that you cannot 
use QueryAddColumn on is a cached query.

This function is particularly useful if you are an Oracle developer and would like to 
generate a query object from the arrays of output parameters which Oracle stored 
procedures can generate. Padding is added, if necessary, on the query columns to 
ensure that all columns have the same number of rows. 

Example

<!--- This example shows the use of QueryAddColumn --->

<HTML>

<HEAD>
<TITLE>
QueryAddColumn Example
</TITLE>
</HEAD>

<basefont face="Arial, Helvetica" size=2>

<body  bgcolor="#FFFFD5">

<BODY>

<H3>QueryAddColumn Example</H3>

<P>This example adds three columns to a query object and then populates 
the columns with the contents of three arrays.</P>  

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

Страница 1: ...Allaire Corporation CFML Language Reference ColdFusion 4 5...

Страница 2: ...ication 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 Allaire Corporati...

Страница 3: ...tures xix Using Examples xix Using Code Snippets xix Using End Tags xx Developer Resources xx About ColdFusion Documentation xxi Documentation updates xxi ColdFusion manuals xxi ColdFusion Server onli...

Страница 4: ...tes 46 CFFILE ACTION Upload 47 Evaluating the results of a file upload 49 CFFILE ACTION Move 51 CFFILE ACTION Rename 52 CFFILE ACTION Copy 53 CFFILE ACTION Delete 54 CFFILE ACTION Read 54 CFFILE ACTIO...

Страница 5: ...FMAIL 135 CFMAILPARAM 138 CFMODULE 140 CFOBJECT 143 CFOBJECT TYPE attributes 143 CFOBJECT Type COM 144 CFOBJECT Type CORBA 146 CFOBJECT Type JAVA 147 CFOUTPUT 149 CFPARAM 151 CFPOP 154 CFPROCESSINGDIR...

Страница 6: ...242 New Functions in ColdFusion 4 5 245 Array Functions 245 Authentication Functions 245 Date and Time Functions 246 Decision Functions 246 Display and Formatting Functions 247 Dynamic Evaluation Fun...

Страница 7: ...itSHLN 287 BitSHRN 288 BitXor 289 Ceiling 290 Chr 291 CJustify 292 Compare 293 CompareNoCase 295 Cos 296 CreateDate 297 CreateDateTime 299 CreateObject 301 Object Types 301 COM 301 CORBA 302 JAVA 303...

Страница 8: ...N 352 GetBaseTagData 353 GetBaseTagList 354 GetBaseTemplatePath 355 GetClientVariablesList 356 GetCurrentTemplatePath 357 GetDirectoryFromPath 358 GetFileFromPath 359 GetFunctionList 360 GetLocale 361...

Страница 9: ...ListDeleteAt 413 ListFind 414 ListFindNoCase 416 ListFirst 417 ListGetAt 418 ListInsertAt 419 ListLast 420 ListLen 421 ListPrepend 422 ListQualify 423 ListRest 425 ListSetAt 426 ListSort 428 ListToAr...

Страница 10: ...QueryAddColumn 481 QueryAddRow 483 QueryNew 484 QuerySetCell 485 QuotedValueList 487 Rand 488 Randomize 489 RandRange 490 REFind 491 REFindNoCase 494 RemoveChars 497 RepeatString 498 Replace 499 Repl...

Страница 11: ...50 URLDecode 551 URLEncodedFormat 552 Val 553 ValueList 554 Week 555 WriteOutput 556 XMLFormat 557 Year 558 YesNoFormat 559 Chapter 3 WDDX JavaScript Objects 561 WddxSerializer Object 562 serialize 56...

Страница 12: ...on or comparison operators 577 Boolean operators 579 Operator Precedence 579 Function Syntax 580 Optional arguments in functions 580 Pound Signs 581 Pound signs inside CFOUTPUT tags 581 Pound signs in...

Страница 13: ...ness systems Developing applications with ColdFusion does not require coding in a traditional programming language instead you build applications by combining standard HTML with a straightforward serv...

Страница 14: ...enhanced fundamental features including email integration server side FTP and HTTP advanced security scheduling and database connectivity again giving you more reliability and new functionality The f...

Страница 15: ...d for clustering 150 MB hard disk space ColdFusion Server 4 5 Professional Edition for Windows Windows 95 98 or Windows NT 4 0 Intel Pentium or above 50 MB hard disk space 32 MB RAM 128 MB recommended...

Страница 16: ...functions instantly and inline as you code Image Map Editor Create image maps right in ColdFusion Studio with a new easy to use visual tool Configuration Wizard Setup your work environment so it meet...

Страница 17: ...downloads of unchanged pages and improve overall site performance Programmatically control refresh of client side cache to ensure users see most up to date output White Space Removal Reduce white spa...

Страница 18: ...attachments Improved Server Side HTTP Use URL redirection SSL cookies return headers and more robust server side HTTP support for building distributed Web applications Security enhancements General OS...

Страница 19: ...larity and to conserve space HTML documentation Each tag or function displays an examples button that you click to execute that element The online example displays two frames one that runs the example...

Страница 20: ...te is designed to give you quick access to the entire range of online resources Allaire Developer Services Resource Description Allaire Web site www allaire com General information about Allaire produ...

Страница 21: ...tions and Allaire products and services For ColdFusion Studio users you can access the documentation update page by clicking on the Help resource tab and browsing your way through the online help tree...

Страница 22: ...u don t have a product CD you can download ColdFusion documentation from the Allaire web site by visiting http www allaire com developer and clicking the Documentation link ColdFusion Studio online do...

Страница 23: ...particular programming problems is to tap into the vast expertise of the ColdFusion developer community on the Allaire Forums Other ColdFusion developers on the forum can help you figure out how to do...

Страница 24: ...61 2100 outside U S and Canada For complete details about Allaire Product Support options please refer to the Allaire Support pages on the Allaire web site http www allaire com support Postings to the...

Страница 25: ...mainder of this chapter provides complete descriptions of each tag listed alphabetically Contents Alphabetical List of ColdFusion Tags 2 New Tags in ColdFusion 4 5 5 ColdFusion Forms Tags 6 Database M...

Страница 26: ...the base tag CFAUTHENTICATE Authenticates a user and sets the security context for an application CFBREAK Breaks out of a CFML looping construct CFCACHE Caches ColdFusion pages CFCOL Defines table col...

Страница 27: ...AM Used with CFHTTP to specify parameters necessary for a CFHTTP POST operation CFIF CFELSEIF CFELSECFIF CFELSEIF CFELSE Used to create IF THEN ELSE constructs CFIMPERSONATE Allows you to impersonate...

Страница 28: ...access the result set from a stored procedure CFQUERY Passes SQL to a database CFQUERYPARAM Reads writes and deletes keys and values in the system registry CFREGISTRY Reads writes and deletes keys and...

Страница 29: ...line text entry box in a CFFORM CFTHROW Raises a developer specified exception CFTRANSACTION Groups CFQUERYs into a single transaction performs rollback processing CFTREE Used in CFFORM to create a tr...

Страница 30: ...andling Tags CFAPPLET CFINPUT CFFORM CFSELECT CFGRID CFSLIDER CFGRIDCOLUMN CFTEXTINPUT CFGRIDROW CFTREE CFGRIDUPDATE CFTREEITEM CFINSERT CFQUERYPARAM CFPROCPARAM CFSTOREDPROC CFPROCRESULT CFTRANSACTIO...

Страница 31: ...rotocol Tags CFCOLLECTION CFSEARCH CFEXECUTE CFSERVLET CFINDEX CFSERVLETPARAM CFOBJECT CFWDDX CFREPORT CFDIRECTORY CFFILE CFABORT CFLOOP CFBREAK CFSWITCH CFCASE CFDEFAULTCASE CFEXECUTE CFTHROW CFIF CF...

Страница 32: ...Manipulation Tags Web Application Framework Tags Other Tags CFOBJECT CFSERVLETPARAM CFSERVLET CFCOOKIE CFSCRIPT CFPARAM CFSET CFAPPLICATION CFERROR CFASSOCIATE CFLOCK CFAUTHENTICATE CFASSOCIATE CFREP...

Страница 33: ...wn all the way up to the line containing the CFABORT tag When using CFABORT with SHOWERROR by itself that is without defining an error page using CFERROR page processing stops once the CFABORT tag is...

Страница 34: ...3 CFSET myVariable 3 now perform a loop that increments this value CFLOOP FROM 1 TO 4 INDEX Counter on the second time through the loop CFABORT CFIF Counter is 2 CFABORT the processing is stopped and...

Страница 35: ..._variable_name HEIGHT pixels WIDTH pixels VSPACE pixels HSPACE pixels ALIGN alignment NOTSUPPORTED text param_1 value param_2 value param_n value APPLETSOURCE Required The name of the registered apple...

Страница 36: ...ministrator Usage Since Java applets must be pre registered the CFAPPLET tag can be very simple taking the default parameter values as they were registered in the ColdFusion Administrator You can also...

Страница 37: ...Optional Yes or No Enables client variables Default is No CLIENTSTORAGE Optional Specifies the mechanism for storing client variables datasourcename ColdFusion stores client variables in the specifie...

Страница 38: ...APPLICATION enables application variables unless they have been disabled in the ColdFusion Administrator Using the SESSIONMANAGEMENT attribute to enable session variables is also overridden by the Adm...

Страница 39: ...n variables that will be used by E Turtleneck Use the session scope for the session variables CFLOCK SCOPE Session TIMEOUT 30 TYPE Exclusive CFIF NOT IsDefined session size CFSET session size CFIF CFI...

Страница 40: ...name is AssocAttribs Use the DataCollection attribute to specify a non default structure name Specify a non default structure name when the base tag can have multiple sub tags and you want to segrega...

Страница 41: ...d its contents include user name security context browser remote address and the HTTP user agent THROWONFAILURE Optional Default is Yes Indicates whether ColdFusion throws an exception of type SECURIT...

Страница 42: ...MLLanguageReference CFOUTPUT Display the message Alternatively you might place code here to define the user to the security domain P CFCATCH message CFOUTPUT CFCATCH CFTRY CFIF CFAPPLICATION NAME Pers...

Страница 43: ...CFQUERY HTML HEAD TITLE CFBREAK Example TITLE HEAD BODY bgcolor silver H1 CFBREAK Example H1 P This example uses CFLOOP to cycle through a query to find a desired value In our example a list of values...

Страница 44: ...esh the cached page If you specify FLUSH you can also specify the DIRECTORY and EXPIREURL attributes CLIENTCACHE Specifies browser caching OPTIMAL Specifies optimal caching through a combination of se...

Страница 45: ...on resources because the browser stores the pages in its own cache thus improving performance The advantage of using a combination of the two forms of caching is that it optimizes performance if the b...

Страница 46: ...hed file is found only one request is required Debug settings have no effect on CFCACHE unless the template explicitly turns it on When generating a cached file CFCACHE uses CFSETTING SHOWDEBUGOUTPUT...

Страница 47: ...can consist of a combination of literal text HTML tags and query record set field references This means you can embed hyperlinks image references and even input controls within table columns Example...

Страница 48: ...nd the text CFML with which to fill the cell CFCOL HEADER B ID B ALIGN Left WIDTH 2 TEXT Emp_ID CFCOL HEADER B Name Email B ALIGN Left WIDTH 15 TEXT a href mailto Email FirstName LastName A CFCOL HEAD...

Страница 49: ...e depends on the ACTION that you specify ACTION What happens CREATE CFCOLLECTION creates a directory for the use of Verity The directory path is composed of the directory path specified in the PATH at...

Страница 50: ...tool other than ColdFusion The ACTION COLLECTION and PATH attributes are required The path must point to a valid Verity collection mapping does not validate the path Deleting a mapped collection unreg...

Страница 51: ...UE Repair CFCOLLECTION ACTION REPAIR COLLECTION FORM CollectionName H3 Collection repaired H3 CFCASE CFCASE VALUE Optimize CFCOLLECTION ACTION OPTIMIZE COLLECTION FORM CollectionName H3 Collection opt...

Страница 52: ...ter the download operation Defaults to No This attribute only applies if you are specifying a file with the FILE attribute FILE Optional Denotes the name of the file being retrieved RESET Optional Yes...

Страница 53: ...BODY HTML This example shows how the RESET attribute changes textual output HTML HEAD TITLE CFCONTENT Example 2 TITLE HEAD BODY H3 CFCONTENT Example 2 H3 P This example shows how the RESET attribute c...

Страница 54: ...URLs within the specified domain to which this cookie applies PATH services login Separate multiple entries with a semicolon DOMAIN Specifies the domain for which the cookie is valid and to which the...

Страница 55: ...Posted FROM Comments CFQUERY HTML HEAD TITLE CFCOOKIE Example TITLE HEAD BODY bgcolor silver H3 CFCOOKIE Example H3 if the URL variable delcookie exists set the cookie s expiration date to NOW CFIF I...

Страница 56: ...True P The last AOL visitor to view this site was CFOUTPUT Cookie LastAOLVisitor CFOUTPUT on CFOUTPUT DateFormat COOKIE TimeVisited CFOUTPUT use this link to reset the cookies P a href cfcookie cfm de...

Страница 57: ...refer to Administering ColdFusion Server for more information about securing ColdFusion tags Syntax CFDIRECTORY ACTION directory action DIRECTORY directory name NAME query name FILTER list filter MODE...

Страница 58: ...s the default For example SORT dirname ASC filename2 DESC size datelastmodified NEWDIRECTORY Required for ACTION Rename Ignored for all other actions The new name of the directory specified in the DIR...

Страница 59: ...3 CFDIRECTORY Example H3 use CFDIRECTORY to give the contents of the snippets directory order by name and size you may need to modify this path CFDIRECTORY DIRECTORY c inetpub wwwroot cfdocs snippets...

Страница 60: ...rocessing of a page Request is the default See the table under CFERROR Error Variables for information about the variables and other constructs available from the templates used to handle each type of...

Страница 61: ...mplate specified in the TEMPLATE attribute of the CFERROR tag may contain one or more error variables which will be substituted by ColdFusion when an error is displayed Types and Their Corresponding C...

Страница 62: ...r Error MailTo Email address of administrator who should be notified corresponds to the value set in the MAILTO attribute of CFERROR Error DateTime Date and time when the error occurred Error Browser...

Страница 63: ...OR is still a good safeguard against general errors P You can also use CFERROR within the Application cfm to specify error handling responsibilities for an entire application Example of CFERROR call w...

Страница 64: ...quotes If ARGUMENTS is passed as an array it is processed as follows On Windows systems the array elements will be concatenated into a string of tokens separated by spaces This string is then passed t...

Страница 65: ...Output File Cannot be opened will be thrown If the effective user of the ColdFusion executing thread does not have permissions to execute the process a security exception will be thrown The time out...

Страница 66: ...custom tag Usage If a CFEXIT tag is encountered outside the context of a custom tag for example in the base page or an included page the tag acts exactly like CFABORT CFEXIT can help simplify error c...

Страница 67: ...t the appropriate sections inside the CFUSION customtags directory MyCustomTag cfm This simple custom tag checks for the existence of myValue1 and myValue2 If they are both defined the tag adds them a...

Страница 68: ...f CFEXIT is used outside of a custom tag it functions like a CFABORT For example the text after this message will not be processed CFEXIT P This text will not be executed due to the existence of the C...

Страница 69: ...These settings are managed using the Basic Security page in the ColdFusion Administrator In order for CFFILE to execute it needs to be enabled on the Basic Security page If you write ColdFusion applic...

Страница 70: ...ions that follow describe these values and attributes in greater detail Attributes Used with CFFILE ACTIONs ACTION Attributes Upload ACCEPT DESTINATION FILEFIELD NAMECONFLICT MODE ATTRIBUTES Move SOUR...

Страница 71: ...neath the root of the Web server document directory NAMECONFLICT Optional Default is error Determines how the file should be handled if its name conflicts with the name of a file that already exists i...

Страница 72: ...le attributes are supported ReadOnly Temporary Archive Hidden System Normal If ATTRIBUTES is not used the file s attributes are maintained If Normal is specified as well as any other attributes Normal...

Страница 73: ...file for example myfile txt ClientDirectory Directory location of the file uploaded from the client s system ClientFile Name of the file uploaded from the client s sys tem ClientFileExt Extension of t...

Страница 74: ...d file and makes permissions read write rw for all FileWasRenamed Indicates Yes or No whether or not the uploaded file was renamed to avoid a name conflict FileWasSaved Indicates Yes or No whether or...

Страница 75: ...ON Required The full path name of the directory to which the file will be moved If you do not specify the file name a trailing slash must be included in the target when moving a file Use the backward...

Страница 76: ...ION Rename SOURCE full_path_name DESTINATION full_path_name ATTRIBUTES file_attributes SOURCE Required The full path name of the file to rename DESTINATION Required The full path name including the ne...

Страница 77: ...st include the trailing slash On Windows use the backward slash On UNIX use the forward slash ATTRIBUTES Optional A comma delimited list of file attributes to be set on the file being copied The follo...

Страница 78: ...ynamic parameter you can use anywhere in the page like any other dynamic parameter For example you could read a text file and then insert its contents into a database Or you could read a text file and...

Страница 79: ...ould first convert it to Base 64 see ToBase64 Syntax CFFILE ACTION ReadBinary FILE full_path_name VARIABLE var_name FILE Required The full path name of the file to be read VARIABLE Required The name o...

Страница 80: ...issions for all ADDNEWLINE Optional Yes or No If this attribute is set to Yes a new line character is appended to the text that is written to the file If this attribute is set to No no new line charac...

Страница 81: ...ory and the file would contain the text Created By World B Frueh Date 10 30 98 We had a wonderful time in Cambridgeport This following examples show the use of the MODE attribute for UNIX The first cr...

Страница 82: ...haracter is appended to the text The default value is Yes ATTRIBUTES Optional A comma delimited list of file attributes to be set on the file being appended The following file attributes are supported...

Страница 83: ...ing the page users are asked if they want to download the CAB file ONSUBMIT Optional JavaScript function to execute after other input validation returns Use this attribute to execute JavaScript for pr...

Страница 84: ...reating a form If you specify a value in quotation marks you must escape the quotation marks by doubling them for example PASSTHROUGH readonly YES The ENABLECAB attribute is supported only for MS Inte...

Страница 85: ...eckbox Test H3 Your checkbox answer was no CFIF CFIF IsDefined form textSample is True AND form textSample is not H3 Results of Credit Card Input H3 Your credit card number CFOUTPUT form textSample CF...

Страница 86: ...er a Credit Card Number VALIDATE creditcard REQUIRED No TD TR TR TD H4 This example shows the use of the CFSLIDER tag H4 P Rate your approval of this example from 1 to 10 by sliding the control P 1 CF...

Страница 87: ...f you write ColdFusion applications designed to run on a server that is used by multiple customers you need to consider the security of the files that the customer can move Please refer to Administeri...

Страница 88: ...he the current FTP connection or to reuse connection information from a previous connection of the same name All calls to CFFTP with the same connection name will reuse the same FTP connection informa...

Страница 89: ...TML HEAD TITLE CFFTP Example TITLE HEAD BODY H3 CFFTP Example H3 P CFFTP allows users to implement File Transfer Protocol operations By default CFFTP caches an open connection to an FTP server P CFFTP...

Страница 90: ...d to respecify the connection attributes USERNAME PASSWORD SERVER Syntax CFFTP ACTION action USERNAME name PASSWORD password NAME query_name SERVER server ASCIIEXTENSIONLIST extensions TRANSFERMODE mo...

Страница 91: ...presentation of UNIX permissions for example 777 when appropriate Note also that there is a CFFTP ReturnValue variable that provides the return value for some of these actions The actions for which th...

Страница 92: ...ith the same connection name will reuse the same FTP connection information ASCIIEXTENSIONLIST Optional A semicolon delimited list of file extensions that force ASCII transfer mode when TRANSFERMODE A...

Страница 93: ...condition PROXYSERVER Optional A string that contains the name of the proxy server or servers to use if proxy access was specified If this parameter is NULL the tag reads proxy information from the re...

Страница 94: ...e is one of the columns returned in the query object as shown in the following table Row is the row number for each file directory entry returned by the ListDir operation A separate row is created for...

Страница 95: ...hed Note that keeping a connection open prevents others from using the FTP server therefore you should close the connection as soon as possible Note Changes to a cached connection such as changing RET...

Страница 96: ...R FTP Directory Listing P CFTABLE QUERY q HTMLTABLE CFCOL HEADER B Name B TEXT name CFCOL HEADER B Path B TEXT path CFCOL HEADER B URL B TEXT url CFCOL HEADER B Length B TEXT length CFCOL HEADER B Las...

Страница 97: ...column_font FONTSIZE size ITALIC Yes No BOLD Yes No HREF URL HREFKEY column_name TARGET URL_target APPENDKEY Yes No HIGHLIGHTHREF Yes No ONVALIDATE javascript_function ONERROR text GRIDDATAALIGN posit...

Страница 98: ...ue Valid entries are Top Left Bottom Baseline Texttop Absbottom Middle Absmiddle Right QUERY Optional The name of the query associated with the grid control INSERT Optional Yes or No Yes allows end us...

Страница 99: ...the value of the selected tree item in the URL to the application page specified in the CFFORM ACTION attribute Default is Yes HIGHLIGHTHREF Optional Yes highlights links associated with a CFGRID wit...

Страница 100: ...text in boldface Default is No ROWHEADERWIDTH Optional The width in pixels of the row header column COLHEADERS Optional Yes or No Yes displays column headers in the grid control Defaults to Yes COLHE...

Страница 101: ...the grid NOTSUPPORTED Optional The text you want to display if the page containing a Java applet based CFFORM control is opened by a browser that does not support Java or has Java support disabled Fo...

Страница 102: ...or the selected row When SELECTMODE Browse no selection data is returned Using SELECTMODE Edit When SELECTMODE Edit one dimensional arrays are used to store data about changes to the grid cells For ex...

Страница 103: ...GRIDUPDATE tags in action use a query to show the useful qualities of CFGRID If the gridEntered form field has been tripped perform the gridupdate on the table specified in the database Using the defa...

Страница 104: ...TAALIGN LEFT BOLD No ITALIC No SELECT No DISPLAY No HEADERBOLD No HEADERITALIC No CFGRIDCOLUMN NAME Dept_ID HEADER Department HEADERALIGN LEFT DATAALIGN LEFT BOLD Yes ITALIC No SELECT Yes DISPLAY Yes...

Страница 105: ...ADERBOLD Yes No DATAALIGN position HEADERALIGN position NUMBERFORMAT format NAME Required A name for the grid column element If the grid uses a query the column name must specify the name of a query c...

Страница 106: ...grid control When No the column cannot be edited even if the CFGRID INSERT or DELETE attributes are enabled The value of the SELECT attribute is ignored if the CFGRID SELECTMODE attribute is set to R...

Страница 107: ...in boldface Default is No DATAALIGN Optional Alignment for column data Valid entries are Left Center or Right Default is Left HEADERALIGN Optional Alignment for the column header text Valid entries ar...

Страница 108: ...NAME Dept_ID HEADER Department HEADERALIGN LEFT DATAALIGN LEFT BOLD Yes ITALIC No SELECT Yes DISPLAY Yes HEADERBOLD No HEADERITALIC Yes CFGRIDCOLUMN NAME CorNumber HEADER Course HEADERALIGN LEFT DATA...

Страница 109: ...CorName HEADER Name HEADERALIGN LEFT DATAALIGN LEFT FONT Times BOLD No ITALIC No SELECT Yes DISPLAY Yes HEADERBOLD No HEADERITALIC No CFGRIDCOLUMN NAME CorLevel HEADER Level HEADERALIGN LEFT DATAALIGN...

Страница 110: ...ntax CFGRIDROW DATA col1 col2 DATA Required A comma separated list of column values If a column value contains a comma character it must be escaped with a second comma character Example use a CFLOOP t...

Страница 111: ...RID form element that is the source for the update action DATASOURCE Required The name of the data source for the update action DBTYPE Optional The database driver type ODBC default ODBC driver Oracle...

Страница 112: ...overrides the password value specified in the ODBC setup TABLEOWNER Optional For data sources that support table ownership such as SQL Server Oracle and Sybase SQL Anywhere use this field to specify t...

Страница 113: ...ered form field has been tripped perform the gridupdate on the table specified in the database Using the default value keyonly yes allows us to change only the information that differs from the previo...

Страница 114: ...ion with the NAME attribute STATUSCODE Required if you do not specify the NAME attribute A number that sets the HTTP status code STATUSTEXT Optional Text that explains the status code This attribute i...

Страница 115: ...quotation marks is placed in the HEAD section Example This example shows the use of CFHTMLHEAD CFHTMLHEAD TEXT TITLE This is an example of a generated header TITLE BASE HREF http www allaire com HTML...

Страница 116: ...agent THROWONERROR Yes No REDIRECT Yes No TIMEOUT timeout_period CFHTTP Note Terminate CFHTTP POST operations with CFHTTP Termination is not required with CFHTTP GET operations URL Required Full URL o...

Страница 117: ...at is accessed For GET operations defaults to the name specified in URL Enter path information in the PATH attribute DELIMITER Required for creating a query Valid characters are a tab or comma Default...

Страница 118: ...YES execution stops if CFHTTP fails and the status code and associated error message are returned in the variable CFHTTP StatusCode To see where execution would have been redirected use the variable...

Страница 119: ...variables returned by CFHTTP GET file into a query To download a file in a ColdFusion page so that a query can be built using the file the file must be either comma separated or tab delimited Althoug...

Страница 120: ...s of a web page from the Internet and shows how you can get the following information by using CFHTTP variables P UL LI display the page fileContent LI derive the MIME type of the page mimeType LI fin...

Страница 121: ...cfhttp statuscode BR H3 B The Raw Header B H3 BR cfhttp header BR CFOUTPUT H3 B Output the Response Headers B H3 BR HR CFLOOP collection CFHTTP RESPONSEHEADER item httpHeader CFSET value CFHTTP RESPON...

Страница 122: ...pecifies the value of the URL FormField Cookie File or CGI variable being passed FILE Required for TYPE File Example This example shows the use of CFHTTPPARAM HTML HEAD TITLE CFHTTPPARAM Example TITLE...

Страница 123: ...PUT BODY HTML CFOUTPUT H3 For CFHTTPPARAM code see right frame H3 P CFHTTP METHOD POST URL http localhost someotherfile cfm CFHTTPPARAM NAME form_test TYPE FormField VALUE This is a form variable CFHT...

Страница 124: ...re is a switch that provides fast date time parsing If you have enabled this switch you must refer to dates in expressions in the following order month day and year For example CFIF 11 23 1998 GT 11 1...

Страница 125: ...a Ana H4 Featured Center in CFIF city is San Diego San Diego CFELSE Santa Ana CFIF H4 B Name Address B Name Address1 City State BR B Contact B Contact BR CFELSE BR I Name City I CFIF CFOUTPUT P Finall...

Страница 126: ...hat you want to impersonate TYPE Required The type of impersonation needed This attribute can have the value CF for impersonation at the application level or OS for impersonation at the operating syst...

Страница 127: ...ed calls in the code to protect each resource Refer to Administering ColdFusion Server for more information about Advanced Security Example This example shows the use of CFIMPERSONATE to impersonate a...

Страница 128: ...ks the directory in which the current page lives Searches directories explicitly mapped in the ColdFusion Administrator for the included file Example This example shows the use of CFINCLUDE to paste p...

Страница 129: ...XTERNAL Yes No LANGUAGE language COLLECTION Required Specifies a collection name If you are indexing an external collection EXTERNAL is Yes specify the collection name including fully qualified path C...

Страница 130: ...other TYPE argument BODY Optional ASCII text to index or a query column name Required if TYPE Custom Ignored for TYPE File and TYPE Path Invalid if TYPE Delete Specifies one of the following The ASCII...

Страница 131: ...fies that directories below the path specified in KEY when TYPE Path will be included in the indexing operation EXTERNAL Optional Yes or No Yes indicates that the collection specified in COLLECTION wa...

Страница 132: ...ection select the check box on the form CFIF IsDefined form IndexCollection CFINDEX ACTION UPDATE COLLECTION Snippets KEY c inetpub wwwroot cfdocs snippets TYPE PATH TITLE Test URLPATH http 127 0 0 1...

Страница 133: ...type ONVALIDATE javascript_function MESSAGE validation_msg ONERROR text SIZE integer MAXLENGTH integer CHECKED Yes No PASSTHROUGH HTML_attributes TYPE Optional Valid entries are Text Creates a text en...

Страница 134: ...er input The form object input object and input object value are passed to the specified routine which should return true if validation succeeds and false otherwise When used the VALIDATE attribute is...

Страница 135: ...nter telephone number formatted xxx xxx xxxx e g 617 761 2000 VALIDATE telephone REQUIRED Yes font size 1 color red Required FONT zip code validation P Zip Code Validation enter a properly formatted z...

Страница 136: ...er Using this option the ColdFusion Server computer must have Oracle 8 0 or greater client software installed Sybase11 Sybase System 11 native database driver Using this option the ColdFusion Server c...

Страница 137: ...ier refers to the directory where the DBF files are located USERNAME Optional If specified USERNAME overrides the username value specified in the ODBC setup PASSWORD Optional If specified PASSWORD ove...

Страница 138: ...ref mailto Email FromUser A TD TD valign top Subject TD TD valign top CommtType TD TD valign top FONT SIZE 2 Left MessText 125 FONT TD TD valign top Posted TD TR CFOUTPUT TABLE P Next we ll offer the...

Страница 139: ...e and or desc or asc DN distinguished_name STARTROW row_number MODIFYTYPE REPLACE or ADD or DELETE REBIND Yes No REFERRAL number_of_allowed_hops SECURE multi_field_security_string SEPARATOR separator_...

Страница 140: ...es OneLevel Default Searches all entries one level beneath the entry specified in the START attribute Base Searches only the entry specified in the START attribute Subtree Searches the entry specified...

Страница 141: ...actions Example cn Barbara Jensen o Ace Industry c US STARTROW Optional Used in conjunction with ACTION Query Specifies the first row of the LDAP query that is to be inserted into the ColdFusion quer...

Страница 142: ...rectory is C cfusion ldap Refer to the Usage section for information about the differences between the two types of security CFSSL_BASIC and CFSSL_CLIENT_AUTH types SEPARATOR Optional Specifies the ch...

Страница 143: ...e all the clients must have certificates which the server must be able to validate and all the certificates must have keys associated with them and passwords to protect those keys Example This example...

Страница 144: ...n FONT TH TH FONT SIZE 2 E Mail FONT TH TH FONT SIZE 2 Phone FONT TH TR CFOUTPUT QUERY results TR TD FONT SIZE 2 cn FONT TD TD FONT SIZE 2 o FONT TD TD FONT SIZE 2 l st c FONT TD TD FONT SIZE 2 A HREF...

Страница 145: ...value of Yes appends client variable information to the URL you specify in the URL argument Example This view only example shows the use of CFLOCATION HTML HEAD TITLE CFLOCATION Example TITLE HEAD BO...

Страница 146: ...cation or Server or Session NAME lockname THROWONTIMEOUT Yes No TYPE ReadOnly Exclusive CFML to be synchronized CFLOCK TIMEOUT Required Specifies the maximum amount of time in seconds to wait to obtai...

Страница 147: ...tiple concurrently executing requests do not manipulate shared data structures files or CFXs in an inconsistent manner Note the following Using CFLOCK around CFML constructs that modify shared data en...

Страница 148: ...onse time may increase if an application has multiple frames that can be refreshed at once thus causing multiple requests to have to queue up and wait to be processed For an analysis of best practices...

Страница 149: ...ocks should do so in a well specified order and name the locks consistently In particular if you need to lock access to the server application and session scopes you must do so in the following order...

Страница 150: ...ncy of data updates to variables in the Application Server and Session scopes You should copy the following code into an Application cfm file in the snippets directory HTML HEAD TITLE Define Session a...

Страница 151: ...tleneck is proud to say that we have sold application number turtlenecks to date CFOUTPUT CFLOCK End of Application cfm HEAD TITLE CFLOCK Example TITLE HEAD BASEFONT FACE Arial Helvetica SIZE 2 BODY b...

Страница 152: ...icate the color and size that you wish to buy P table cellspacing 2 cellpadding 2 border 0 tr td Select a color td td SELECT TYPE Text NAME color OPTION red OPTION white OPTION blue OPTION turquoise O...

Страница 153: ...FOR loops as in loop FOR this range of values Syntax CFLOOP INDEX parameter_name FROM beginning_value TO ending_value STEP increment HTML or CFML code to execute CFLOOP INDEX Required Defines the para...

Страница 154: ...The loop index is 2 The loop index is 1 Conditional Loops A conditional loop iterates over a set of instructions while a given condition is TRUE To use this type of loop correctly the instructions mu...

Страница 155: ...RTROW row_num ENDROW row_num QUERY Required Specifies the query that will control the loop STARTROW Optional Specifies the first row of the query that will be included in the loop ENDROW Optional Spec...

Страница 156: ...etTemplate DATASOURCE Library MAXROWS 5 SELECT TemplateName FROM Templates CFQUERY CFLOOP QUERY TemplateName CFINCLUDE TEMPLATE TemplateName CFLOOP Looping over a List Looping over a list offers the o...

Страница 157: ...ing over a COM Collection or Structure The CFLOOP COLLECTION attribute allows you to loop over a structure or a COM DCOM collection object A COM DCOM collection object is a set of similar items refere...

Страница 158: ...ough a structure used as an associative array Create a structure and loop through its contents CFSET Departments StructNew CFSET val StructInsert Departments John Sales CFSET val StructInsert Departme...

Страница 159: ...tains address information such as TO EMail In the latter case an individual email message is sent for every row returned by the query FROM Required The sender of the email message This attribute may b...

Страница 160: ...single email message For example if you send a set of billing statements out to your customers you might group on Customer_ID The GROUP attribute which is case sensitive eliminates adjacent duplicates...

Страница 161: ...This message was sent by an automatic mailer built with CFMAIL form body CFMAIL H3 Thank you H3 P Thank you CFOUTPUT mailfrom your message subject has been sent to mailto CFOUTPUT CFIF CFIF P FORM AC...

Страница 162: ...UE header value CFMAIL FILE Required if you do not specify the NAME attribute Attaches the specified file to the message This attribute is mutually exclusive with the NAME attribute NAME Required if y...

Страница 163: ...domain com Subject See Important Attachments and Reply CFMAILPARAM NAME Reply To VALUE mary domain com Please read the text file and view the new logo and let us know what you think CFMAILPARAM FILE...

Страница 164: ...e of the custom tag in the form Name Name Name that uniquely identifies a subdirectory containing the custom tag page under the root directory for CF custom tags For example CFMODULE NAME Allaire Foru...

Страница 165: ...sion custom tags in the Cfusion CustomTags directory For more information about using Custom Tags please refer to i Developing Web Applications i P show the code in the custom tag P Here is the code i...

Страница 166: ...ustom tag using the NAME attribute P CFOUTPUT HTMLCodeFormat CFMODULE NAME myTag X 3 attributeCollection attrCollection1 Y 4 CFOUTPUT P The result CFOUTPUT result CFOUTPUT Call the tag using the short...

Страница 167: ...FOBJECT Type COM CFOBJECT Type CORBA CFOBJECT Type JAVA CFOBJECT TYPE attributes Depending on the value you assign to the TYPE attribute of CFOBJECT there are several additional attributes you can set...

Страница 168: ...n for most COM objects Syntax CFOBJECT TYPE COM ACTION action CLASS program_ID NAME text CONTEXT context SERVER server_name ACTION Required One of the following Create Use Create to instantiate a COM...

Страница 169: ...e called using empty parenthesis CFSET obj Init This object is a collection object and should support at a minimum Property Count Method Item inarg outarg and a special property called _NewEnum CFOUTP...

Страница 170: ...SS Required Specifies different information depending on the CONTEXT specification If CONTEXT is IOR Specifies the name of a file that contains the stringified version of the IOR ColdFusion must be ab...

Страница 171: ...ension EJB objects This support is currently only for NT but will be extended to Solaris in the next release Syntax CFOBJECT ACTION Create TYPE Java CLASS Java class NAME object name ACTION Required S...

Страница 172: ...create and call all the appropriate EJB objects use CFOBJECT The sequence in the second example assumes that the Weblogic JNDI is used to register and find EJBHome instances Example of Java Object Thi...

Страница 173: ...e GROUP attribute which is case sensitive eliminates adjacent duplicates in the case where the data is sorted by the specified field See the GROUPCASESENSITIVE attribute for information about specifyi...

Страница 174: ...UTPUT DateFormat Now CFOUTPUT P In addition CFOUTPUT may be used to show the results of a query operation or only a partial result as shown P There are CFOUTPUT getCourses recordCount CFOUTPUT total r...

Страница 175: ...does not exist TYPE Optional The type of parameter that is required The default value is any DEFAULT Optional Default value to set the parameter to if it does not exist Type Values Type Value Descript...

Страница 176: ...d set to the value of the DEFAULT attribute Example This example shows how CFPARAM operates CFPARAM NAME storeTempVar DEFAULT my default value CFPARAM NAME tempVar DEFAULT my default value check if fo...

Страница 177: ...Chapter 1 ColdFusion Tags 153 P FORM ACTION cfparam cfm METHOD POST Type in a new value for tempVar and hit submit BR INPUT TYPE Text NAME tempVar INPUT TYPE Submit NAME VALUE submit FORM BODY HTML...

Страница 178: ...s PASSWORD Optional Password corresponds to user name ACTION Optional Specifies the mail action There are three possible values GetHeaderOnly Default Returns message header information only GetAll Ret...

Страница 179: ...d ATTACHMENTPATH is specified no attachment files are written to the server TIMEOUT Optional Specifies the maximum amount of time in seconds to wait for mail processing Defaults to 60 seconds MAXROWS...

Страница 180: ...ent row of the query being processed by CFOUTPUT queryname ColumnList The list of the column names in the query CFPOP Query Variables Continued Variable Names Description Message Header and Body Colum...

Страница 181: ...allowing you to display the mail headers in a POP3 mailbox P Simply uncomment this code and run with a mail enabled CF Server to see this feature in action CFIF IsDefined form server make sure server...

Страница 182: ...t Subject CFOUTPUT UL CFIF CFIF FORM ACTION cfpop cfm METHOD POST P Enter your mail server P INPUT TYPE Text NAME server P Enter your username P INPUT TYPE Text NAME username P Enter your password P I...

Страница 183: ...tag s settings within the body of the inner tag where they differ If the enclosing tag specifies settings that the inner tag does not those settings remain in effect within the inner tag s scope CFPR...

Страница 184: ...use to reference the value that the output parameter represents after the call is made to the stored procedure DBVARNAME Required if named notation is desired This is the parameter name This correspon...

Страница 185: ...the order in which they are defined Named notation If named notation is used the DBVarName for the parameter must correspond to the variable name in the stored procedure on the server Output variables...

Страница 186: ...COL br CFOUTPUT P CFOUTPUT hr P Record Count RS1 RecordCount p Columns RS1 ColumnList hr CFOUTPUT CFOUTPUT QUERY RS3 col1 col2 col3 br CFOUTPUT P CFOUTPUT hr P Record Count RS3 RecordCount P Columns R...

Страница 187: ...esult set Usage Specify one or more CFPROCRESULT tags to enable access to data returned by the stored procedure RESULTSET must be unique within the scope of the CFSTOREDPROC tag If you specify the sam...

Страница 188: ...TPUT QUERY RS1 NAME DATE_COL br CFOUTPUT P CFOUTPUT hr P Record Count RS1 RecordCount p Columns RS1 ColumnList hr CFOUTPUT CFOUTPUT QUERY RS3 col1 col2 col3 br CFOUTPUT P CFOUTPUT hr P Record Count RS...

Страница 189: ...r in the page to reference the query s record set DATASOURCE Required The name of the data source from which this query should retrieve data DBTYPE Optional The database driver type ODBC default ODBC...

Страница 190: ...to 100 This parameter applies to ORACLE native database drivers and to ODBC drivers Certain ODBC drivers may dynamically reduce the block factor at runtime TIMEOUT Optional Lets you specify a maximum...

Страница 191: ...onal Used for debugging queries Specifying this attribute causes the SQL statement actually submitted to the data source and the number of records returned from the query to be output Usage In additio...

Страница 192: ...Name State CFQUERY build HTML table to display query TABLE cellpadding 1 cellspacing 1 TR TD colspan 2 bgcolor f0f0f0 B I Park Name I B TD TD bgcolor f0f0f0 B I Region I B TD TD bgcolor f0f0f0 B I Sta...

Страница 193: ...offer a link to the same page with the StartRow value incremented by MaxRows in the case of this example incremented by 10 TR TD colspan 4 CFIF StartRow MaxRows LTE GetParks RecordCount a href cfquer...

Страница 194: ...value CFSQLType parameter type MAXLENGTH maximum parameter length SCALE number of decimal places DBNAME database name NULL Yes No AND OR additional criteria of the WHERE clause CFQUERY VALUE Required...

Страница 195: ...parameters If a database does not support bind parameters ColdFusion still performs validation and substitutes the validated parameter value back into the string If validation fails an error message i...

Страница 196: ...UERYPARAM VALUE Course_ID CFSQLType CF_SQL_INTEGER CFQUERY CFOUTPUT QUERY getFirst P Course Number number br Description descript P CFOUTPUT BODY HTML This example shows the use of CFQUERYPARAM when i...

Страница 197: ...t h3 CFSET LastName Peterson DELETE employees WHERE LastName Peterson Note that for string input you must specify the MAXLENGTH attribute for validation CFQUERY NAME getFirst DATASOURCE cfsnippets SEL...

Страница 198: ...e Basic Security page Please refer to Administering ColdFusion Server for more information about securing ColdFusion tags CFREGISTRY topics CFREGISTRY ACTION GetAll CFREGISTRY ACTION Get CFREGISTRY AC...

Страница 199: ...urn keys and values NAME Required The name of the record set to contain returned keys and values SORT Optional Sorts query column data case insensitive Sorts on Entry Type and Value columns as text Sp...

Страница 200: ...e b WIDTH 10 TEXT RegQuery Type CFCOL HEADER B Value b WIDTH 35 TEXT RegQuery Value CFTABLE BODY HTML CFREGISTRY ACTION Get Use CFREGISTRY with the Get action to access a registry value and store it i...

Страница 201: ...PE String VARIABLE RegValue H1 CFREGISTRY ACTION Get H1 CFOUTPUT P Java ClassPath value is RegValue CFOUTPUT BODY HTML CFREGISTRY ACTION Set Use CFREGISTRY with the Set action to add a registry key ad...

Страница 202: ...ne here CFSET FileName dummy cfm CFREGISTRY ACTION Set BRANCH HKEY_LOCAL_MACHINE Software cflangref ENTRY LastCFM01 TYPE String VALUE FileName H1 CFREGISTRY ACTION Set H1 BODY HTML CFREGISTRY ACTION D...

Страница 203: ...ed beneath the key Example This example uses CFREGISTRY with the Delete Action to remove a key from the registry HTML HEAD TITLE CFREGISTRY ACTION Delete TITLE HEAD BODY CFREGISTRY ACTION Delete BRANC...

Страница 204: ...ion Administrator PASSWORD Optional The password that corresponds to a username required for database access Overrides the default settings for the data source in the ColdFusion Administrator FORMULA...

Страница 205: ...P This example would run a report called monthlysales rpt and pass it an optional filter condition to show only the information for a certain subset of the report CFREPORT REPORT reports monthlysales...

Страница 206: ...W HTML HEAD TITLE CFRETHROW Example TITLE HEAD BASEFONT FACE Arial Helvetica SIZE 2 BODY bgcolor FFFFD5 H3 CFRETHROW Example H3 Rethrow a DATABASE exception CFTRY CFTRY CFQUERY NAME myQuery1 DATASOURC...

Страница 207: ...Chapter 1 ColdFusion Tags 183 CFCATCH CFTRY BODY HTML...

Страница 208: ...se require CFSET statements For more information on CFScript see Developing Web Applications with ColdFusion Example This example shows the use of CFSCRIPT HTML HEAD TITLE CFSCRIPT Example TITLE HEAD...

Страница 209: ...th fully qualified path Collection names are defined either through the CFCOLLECTION tag or in the ColdFusion Administrator Verity page Multiple ColdFusion collections can be specified in a comma sepa...

Страница 210: ...s assumed Every search conducted with the CFSEARCH tag returns as part of the record set a number of result columns you can reference in your CFOUTPUT URL Returns the value of the URLPATH attribute de...

Страница 211: ...DocSearch SCORE Example This example shows how to utilize CFSEARCH to search an existing populated collection HTML HEAD TITLE CFSEARCH Example TITLE HEAD BODY bgcolor silver H3 CFSEARCH Example H3 To...

Страница 212: ...dsSearched total record CFIF SearchSnippets recordcount is not 1 s CFIF searched P I B form maxrows records returned B I CFTABLE QUERY SearchSnippets MAXROWS maxrows STARTROW 1 COLHEADERS HTMLTABLE CF...

Страница 213: ...A name for the form you are creating SIZE Optional Size of the drop down list box in number of entries REQUIRED Optional Yes or No If Yes a list element must be selected when the form is submitted De...

Страница 214: ...oubling them for example PASSTHROUGH readonly YES CFSELECT supports the JavaScript onClick event in the same manner as the HTML INPUT tag CFSELECT NAME dept MESSAGE You must select a department name Q...

Страница 215: ...ABLECAB Yes Use CFSELECT to present the contents of the query by column H3 CFSELECT Presentation of Data H3 H4 Click on an employee s last name and hit see information for this employee to see expande...

Страница 216: ...efault JRun listens at port 8081 TIMEOUT Optional Specifies how many seconds JRun should wait for the servlet to complete before timing out WRITEOUTPUT Optional Boolean specifying if the text output o...

Страница 217: ...reloaded by JRun if they change Example CFSERVLET CODE MyServletName JRUNPROXY 236 3 3 4 8083 TIMEOUT 300 WRITEOUTPUT YES CFSERVLETPARAM NAME Param1 VALUE Value1 CFSERVLETPARAM NAME Param2 VALUE Valu...

Страница 218: ...al The value of a name value pair to be passed to the servlet as a parameter VARIABLE Optional The name of a ColdFusion variable See the Usage section for details on passing parameters The value of wh...

Страница 219: ...value of the ColdFusion variable The VARIABLE attribute represents the name not the value of a ColdFusion variable This ability to directly share ColdFusion variables with a servlet is a powerful exte...

Страница 220: ...me JRUNPROXY 236 3 3 4 8083 TIMEOUT 300 WRITEOUTPUT Yes DEBUG Yes CFSERVLETPARAM NAME Param1 VALUE Value1 CFSERVLETPARAM NAME Param2 VALUE Value2 CFSERVLETPARAM NAME Attribute1 VARIABLE CFVar1 TYPE BO...

Страница 221: ...variable names In this example the variable name is itself a variable CFSET myvariable current_value CFSET myvariable 5 COM objects In this example a COM object is created A CFSET defines a value for...

Страница 222: ...ddition CFSET can be used to pass variables from other pages such as this example which takes the url parameter Test from this link a href cfset cfm test CFOUTPUT URLEncodedFormat hey you get off of m...

Страница 223: ...uctured exception handling introduces a subtle upwards incompatibility In 4 0 x an exception was handled by the first CFCATCH block that could handle that type of exception In 4 5 the structured excep...

Страница 224: ...200 CFMLLanguageReference CFOUTPUT P Text within CFOUTPUT is always shown CFOUTPUT BODY HTML...

Страница 225: ...ENT Example HTML HEAD TITLE CFSILENT TITLE HEAD BASEFONT FACE Arial Helvetica SIZE 2 BODY bgcolor FFFFD5 H3 CFSILENT H3 This example shows the use of CFSILENT CFSILENT CFSET a 100 CFSET b 99 CFSET c b...

Страница 226: ...NVALIDATE script_name MESSAGE text ONERROR text HEIGHT integer WIDTH integer VSPACE integer HSPACE integer ALIGN alignment GROOVECOLOR color BGCOLOR color TEXTCOLOR color FONT font_name FONTSIZE integ...

Страница 227: ...00 and so on VALUE Optional Determines the default slider setting Must be within the values specified in RANGE Defaults to the minimum value specified in RANGE ONVALIDATE Optional The name of a valid...

Страница 228: ...the slider box moves Valid entries are black magenta cyan orange darkgray pink gray white lightgray yellow A hex value can be entered in the form GROOVECOLOR xxxxxx Where x is 0 9 or A F Use either t...

Страница 229: ...s specified the following message appears B Browser must support Java to BR view ColdFusion Java Applets B Example This example shows how to use CFSLIDER within CFFORM HTML HEAD TITLE CFSLIDER Example...

Страница 230: ...MESSAGE Slide the bar to get a value between 1 and 100 HEIGHT 20 WIDTH 150 FONT Verdana BGCOLOR Silver GROOVECOLOR Lime BOLD No ITALIC Yes REFRESHLABEL Yes 100 P INPUT TYPE Submit NAME VALUE Show the...

Страница 231: ...ta source that points to the database containing the stored procedure USERNAME Optional If specified USERNAME overrides the username value specified in the data source setup PASSWORD Optional If speci...

Страница 232: ...a variable called CFSTOREDPROC ExecutionTime This variable contains the number of milliseconds that it took the stored procedure to execute Stored procedures represent an advanced feature found in hi...

Страница 233: ...Y RS1 NAME DATE_COL br CFOUTPUT P CFOUTPUT hr P Record Count RS1 RecordCount p Columns RS1 ColumnList hr CFOUTPUT CFOUTPUT QUERY RS3 col1 col2 col3 br CFOUTPUT P CFOUTPUT hr P Record Count RS3 RecordC...

Страница 234: ...If a value matches the expression CFSWITCH executes the code between the CFCASE start and end tags Separate multiple values with a comma or an alternative delimiter as specified in the DELIMITERS par...

Страница 235: ...ng CFSWITCH we can classify the output without using a CFLOOP construct CFOUTPUT QUERY GetEmployees CFSWITCH EXPRESSION Department each time the case is fulfilled the specific information is printed i...

Страница 236: ...DER COLHEADERS STARTROW row_number CFTABLE QUERY Required The name of the CFQUERY from which you want to draw data MAXROWS Optional Specifies the maximum number of rows you want to display in the tabl...

Страница 237: ...l Phone Department FROM Employees CFQUERY HTML HEAD TITLE CFTABLE Example TITLE HEAD BODY H3 CFTABLE Example H3 Note the use of the HTMLTABLE attribute to display the CFTABLE as an HTML table rather s...

Страница 238: ...RROR text SIZE integer FONT font_name FONTSIZE integer ITALIC Yes No BOLD Yes No HEIGHT integer WIDTH integer VSPACE integer HSPACE integer ALIGN alignment BGCOLOR color TEXTCOLOR color MAXLENGTH inte...

Страница 239: ...laced with a blank ONVALIDATE Optional The name of a valid JavaScript function used to validate user input The form object input object and input object value are passed to the specified routine which...

Страница 240: ...ue Valid entries are Top Left Bottom Baseline TextTop AbsBottom Middle AbsMiddle Right BGCOLOR Optional Background color of the control Valid entries are black magenta cyan orange darkgray pink gray w...

Страница 241: ...of CFTEXTINPUT HTML HEAD TITLE CFTEXTINPUT Example TITLE HEAD BODY bgcolor silver H3 CFTEXTINPUT Example H3 CFTEXTINPUT can be used to provide simple validation for text fields in CFFORM and to have...

Страница 242: ...pe is the default CFCATCH type MESSAGE Optional A message that describes the exceptional event DETAIL Optional A detailed description of the event The ColdFusion server appends the position of the err...

Страница 243: ...H3 CFTHROW Example H3 open a CFTRY block CFTRY define a condition upon which to throw the error CFIF NOT IsDefined URL myID throw the error CFTHROW MESSAGE ID is not defined CFIF perform the error ca...

Страница 244: ...ad_Committed Repeatable_Read Serializable Usage A transaction block is created within these tags CFTRANSACTION queries to be executed CFTRANSACTION Within the transaction block you can commit a transa...

Страница 245: ...ansaction in a CFTRY CFCATCH block in order to catch database errors and make commitment or rollback or the transaction contingent on the errors received CFTRY Initialize commitIt to Yes CFSET commitI...

Страница 246: ...ption myCorLevel Now CFQUERY Rolls back the pending insertion if database exception is caught CFCATCH TYPE DATABASE CFTRANSACTION ACTION ROLLBACK CFSET commitIt No CFCATCH CFIF commitIt CFTRANSACTION...

Страница 247: ...ALIDATE script_name MESSAGE text ONERROR text FONT font FONTSIZE size ITALIC Yes No BOLD Yes No HEIGHT integer WIDTH integer VSPACE integer HSPACE integer ALIGN alignment BORDER Yes No HSCROLL Yes No...

Страница 248: ...erwise MESSAGE Optional Message text to appear if validation fails ONERROR Optional The name of a valid JavaScript function you want to execute in the event of a failed validation FONT Optional Font n...

Страница 249: ...appears B Browser must support Java to BR view ColdFusion Java Applets B Example This example shows the use of CFTREE in a CFFORM The query takes a list of employees and uses CFTREE and CFSELECT to d...

Страница 250: ...Loop through the query to create each branch of the CFTREE H3 CFTREE Presentation of Data H3 H4 Click on the folders to drill down and reveal information H4 P CFTREEITEM is used to create the branche...

Страница 251: ...pter 1 ColdFusion Tags 227 EXPAND No QUERYASROOT No CFTREEITEM VALUE Email DISPLAY Email PARENT Emp_ID QUERYASROOT No EXPAND No CFTREEITEM VALUE Email PARENT Email EXPAND No QUERYASROOT No CFLOOP CFTR...

Страница 252: ...is submitted When populating a CFTREE with data from a CFQUERY columns are specified in a comma separated list VALUE dept_id emp_id DISPLAY Optional The label for the tree item Default is VALUE When...

Страница 253: ...l HTML HREF When populating a CFTREE with data from a CFQUERY HREFs can be specified in a comma separated list HREF http dept_server http emp_server TARGET Optional Target attribute for HREF URL When...

Страница 254: ...LECT to present the contents of the query by column H3 CFSELECT Presentation of Data H3 H4 Click on an employee s last name and hit see information for this employee to see expanded information H4 CFS...

Страница 255: ...ASROOT No CFTREEITEM VALUE Department DISPLAY Department PARENT Emp_ID QUERYASROOT No EXPAND No CFTREEITEM VALUE Department PARENT Department EXPAND No QUERYASROOT No CFTREEITEM VALUE Phone DISPLAY Ph...

Страница 256: ...atabase Template Security Object MissingInclude Expression Lock Custom_type Any default Usage You must code at least one CFCATCH tag within a CFTRY block Code CFCATCH tags at the end of the CFTRY bloc...

Страница 257: ...s having the APPLICATION type in the CFTHROW tag that defines them The tags that throw an exception of TYPE TEMPLATE are CFINCLUDE CFMODULE and CFERROR An exception raised within a CFCATCH block canno...

Страница 258: ...tom error message Note In order to see the tag stack displayed by TagContext use the ColdFusion Administrator to enable the CFML stack trace Under Debugging in the ColdFusion Administrator choose the...

Страница 259: ...P CFCATCH message P P Caught an exception type CFCATCH TYPE P P The contents of the tag stack are P CFLOOP index i from 1 to ArrayLen CFCATCH TAGCONTEXT CFSET sCurrent CFCATCH TAGCONTEXT i BR i sCurre...

Страница 260: ...er Using this option the ColdFusion Server computer must have Oracle 8 0 or greater client software installed Sybase11 Sybase System 11 native database driver Using this option the ColdFusion Server c...

Страница 261: ...directory where the DBF files are located USERNAME Optional If specified USERNAME overrides the username value specified in the ODBC setup PASSWORD Optional If specified PASSWORD overrides the passwor...

Страница 262: ...ts of this record and then click submit to use CFUPDATE and alter the database H3 P Course Number INPUT TYPE Text NAME number VALUE CFOUTPUT GetCourseInfo number CFOUTPUT P Course Description BR TEXTA...

Страница 263: ...t of the operation This attribute is required for ACTION WDDX2CFML For all other actions if this attribute is not provided the result of the WDDX processing is outputted in the HTML stream TOPLEVELVAR...

Страница 264: ...id Username from messages CFQUERY The recordset data is P CFOUTPUT QUERY q Message_ID Thread_ID Username br CFOUTPUT P Serialize data to WDDX format Serializing CFML data P CFWDDX ACTION cfml2wddx inp...

Страница 265: ...provides complete descriptions of each function listed alphabetically Contents Alphabetical List of ColdFusion Functions 242 New Functions in ColdFusion 4 5 245 Array Functions 245 Authentication Fun...

Страница 266: ...icData ArrayMin Compare Decrypt GetTempDirectory ArrayNew CompareNoCase DeleteClientVariable GetTempFile ArrayPrepend Cos DirectoryExists GetTemplatePath ArrayResize CreateDate DollarFormat GetTickCou...

Страница 267: ...LSCurrencyFormat QueryAddColumn SpanExcluding JSStringFormat LSDateFormat QueryAddRow SpanIncluding LCase LSEuroCurrencyFormat QueryNew Sqr Left LSIsCurrency QuerySetCell StripCR Len LSIsDate QuotedV...

Страница 268: ...244 CFMLLanguageReference Tan ToString URLEncodedFormat WriteOutput TimeFormat Trim Val XMLFormat ToBase64 UCase ValueList Year ToBinary URLDecode Week YesNoFormat...

Страница 269: ...oBinary GetMetricData ToString IsBinary URLDecode JSStringFormat XMLFormat ArrayAppend ArrayMax ArraySum ArrayAvg ArrayMin ArraySwap ArrayClear ArrayNew ArrayToList ArrayDeleteAt ArrayPrepend IsArray...

Страница 270: ...eODBCTime DayOfYear MonthAsString CreateTime DaysInMonth Now CreateTimeSpan DaysInYear ParseDateTime DateCompare FirstDayOfMonth Quarter DateConvert GetTimeZoneInfo Second DateDiff Hour Week DateForma...

Страница 271: ...t LSTimeFormat FormatBaseN NumberFormat HTMLCodeFormat ParagraphFormat HTMLEditFormat TimeFormat LSCurrencyFormat YesNoFormat LSDateFormat DE IIf Evaluate SetVariable DateConvert LSIsNumeric GetLocale...

Страница 272: ...ListRest ListDeleteAt ListSetAt ListFind ListSort ListFindNoCase ListToArray ListFirst ListValueCount ListGetAt ListValueCountNoCase ListInsertAt Abs BitXor Max ACos Ceiling Min ASin Cos Pi Atn Decre...

Страница 273: ...ify ListValueCountNoCase ReplaceNoCase Compare LSParseCurrency REReplace CompareNoCase LSParseDateTime REReplaceNoCase DayOfWeekAsString LSParseEuroCurrency Reverse FormatBaseN LSParseNumber Right Fin...

Страница 274: ...StructUpdate StructInsert DirectoryExists GetFileFromPath ExpandPath GetMetricData FileExists GetTempFile GetCurrentTemplatePath GetTemplatePath GetDirectoryFromPath SetProfileString CreateObject Get...

Страница 275: ...Syntax Abs number number Any number Examples This example shows how to use the ABS function HTML HEAD TITLE Abs Example TITLE HEAD BODY BGCOLOR silver H3 Abs Example H3 P The absolute value of the fol...

Страница 276: ...shows how to use ACos HTML HEAD TITLE ACos Example TITLE HEAD BODY BGCOLOR silver H3 ACos Example H3 output its arccosine value CFIF IsDefined FORM CosNum CFIF IsNumeric FORM CosNum CFIF FORM CosNum L...

Страница 277: ...sion Functions 253 CFIF FORM ACTION acos cfm METHOD POST P Type in a number to get its arccosine in Radians and Degrees BR INPUT TYPE Text NAME cosNum size 25 P INPUT TYPE Submit NAME INPUT TYPE RESET...

Страница 278: ...TITLE HEAD BODY H3 ArrayAppend Example H3 CFQUERY NAME GetEmployeeNames DATASOURCE cfsnippets SELECT FirstName LastName FROM Employees CFQUERY create an array CFSET myArray ArrayNew 1 set element one...

Страница 279: ...F Form Submit is More CFSET FormElem ListLen Form Fieldnames CFIF CFIF HTML HEAD TITLE ArrayAvg Example TITLE HEAD BODY H3 ArrayAvg Example H3 P This example uses ArrayAvg to find the average of the n...

Страница 280: ...yNew 1 CFSET Count 1 CFLOOP index ListItem list Form Fieldnames CFIF Left ListItem 3 is Num CFSET myNumberArray Count Val Evaluate number Count CFSET count IncrementValue Count CFIF CFLOOP CFIF Form S...

Страница 281: ...TLE HEAD BODY H3 ArrayClear Example H3 create a new array CFSET MyArray ArrayNew 1 populate an element or two CFSET MyArray 1 Test CFSET MyArray 2 Other Test output the contents of the array P Your ar...

Страница 282: ...also ArrayInsertAt Syntax ArrayDeleteAt array position array Name of the array in which you want to delete index data specified in position position Array position containing the data you want to dele...

Страница 283: ...ant to insert the data specified in value value The value of the data you want to insert into the array Example This example shows ArrayInsertAt HTML HEAD TITLE ArrayInsertAt Example TITLE HEAD BODY H...

Страница 284: ...y Example TITLE HEAD BODY H3 ArrayIsEmpty Example H3 create a new array CFSET MyArray ArrayNew 1 populate an element or two CFSET MyArray 1 Test CFSET MyArray 2 Other Test output the contents of the a...

Страница 285: ...ets SELECT FirstName LastName FROM Employees CFQUERY create an array CFSET myArray ArrayNew 1 set element one to show where we are CFSET myArray 1 Test Value loop through the query and append these na...

Страница 286: ...een submitted the following code creates an array and assigns the form fields to the first two elements in the array CFIF IsDefined FORM submit CFSET myNumberArray ArrayNew 1 CFSET myNumberArray 1 num...

Страница 287: ...Chapter 2 ColdFusion Functions 263 INPUT TYPE text NAME number2 BR INPUT TYPE submit NAME submit VALUE Maximum Value FORM BODY HTML...

Страница 288: ...submitted the following code creates an array and assigns the form fields to the first two elements in the array CFIF IsDefined FORM submit CFSET myNumberArray ArrayNew 1 CFSET myNumberArray 1 FORM nu...

Страница 289: ...Chapter 2 ColdFusion Functions 265 INPUT TYPE text NAME number2 BR INPUT TYPE submit NAME submit VALUE Minimum Value FORM BODY HTML...

Страница 290: ...ple H3 Make an array CFSET MyNewArray ArrayNew 1 Note that ArrayToList will not function properly if the Array has not been initialized with ArraySet CFSET temp ArraySet MyNewArray 1 6 set some elemen...

Страница 291: ...E GetEmployeeNames DATASOURCE cfsnippets SELECT FirstName LastName FROM Employees CFQUERY create an array CFSET myArray ArrayNew 1 set element one to show where we are CFSET myArray 1 Test Value loop...

Страница 292: ...ray minimum_size array Name of the array you want to resize minimum_size Minimum size of the specified array Example This example shows the use of ArrayResize HTML HEAD TITLE ArrayResize Example TITLE...

Страница 293: ...nding position in the specified array If this value exceeds the array length elements are accordingly added to the array value The value you want to add to the range of elements in the specified array...

Страница 294: ...to enforce asc Default Ascending sort order desc Descending sort order Example This example shows ArraySort HTML HEAD TITLE ArraySort Example TITLE HEAD BODY CFQUERY NAME GetEmployeeNames DATASOURCE c...

Страница 295: ...ee if the form has been submitted the following code creates an array and assigns the form fields to the first two elements in the array CFIF IsDefined FORM submit CFSET myNumberArray ArrayNew 1 CFSET...

Страница 296: ...272 CFMLLanguageReference INPUT TYPE text NAME number2 BR INPUT TYPE submit NAME submit VALUE Add FORM BODY HTML...

Страница 297: ...tion2 array Name of the array whose elements you want to swap position1 Position of the first element you want to swap position2 Position of the second element you want to swap Example This example sh...

Страница 298: ...LastName FROM Employees CFQUERY create an array CFSET myArray ArrayNew 1 loop through the query and append these names successively to the last element CFLOOP query GetEmployeeNames CFSET temp ArrayA...

Страница 299: ...R silver H3 Asc Example H3 if the character string is not empty then output its ascii value CFIF IsDefined FORM charVals CFIF FORM charVals is not CFOUTPUT Left FORM charVals 1 Asc FORM charVals CFOUT...

Страница 300: ...efined FORM SinNum CFIF IsNumeric FORM SinNum CFIF FORM SinNum LESS THAN OR EQUAL TO 1 CFIF FORM SinNum GREATER THAN OR EQUAL TO 1 ASin CFOUTPUT FORM SinNum CFOUTPUT CFOUTPUT Evaluate ASin FORM sinNum...

Страница 301: ...be calculated in degrees and radians This value must be between 1 and 1 inclusive H4 CFIF CFIF FORM ACTION asin cfm METHOD POST P Type in a number to get its arcsine in Radians and Degrees BR INPUT TY...

Страница 302: ...nippet shows how to use Atn HTML HEAD TITLE Atn Example TITLE HEAD BODY BGCOLOR silver H3 Atn Example H3 output its Atn value CFIF IsDefined FORM AtnNum CFIF IsNumeric FORM atnNum Atn CFOUTPUT FORM at...

Страница 303: ...AuthenticatedUser IsAuthorized and CFAUTHENTICATE Syntax AuthenticatedContext Examples This snippet shows how to use AuthenticatedContext HTML HEAD TITLE AuthenticatedContext Example TITLE HEAD BODY...

Страница 304: ...nticated AuthenticatedContext and CFAUTHENTICATE Syntax AuthenticatedUser Examples This snippet shows how to use AuthenticatedUser HTML HEAD TITLE AuthenticatedUser Example TITLE HEAD BODY BGCOLOR sil...

Страница 305: ...2 Any long integers Usage Bit functions operate on 32 bit integers Examples This example shows BitAnd HTML HEAD TITLE BitAnd Example TITLE HEAD BODY H3 BitAnd Example H3 P Returns the bitwise AND of t...

Страница 306: ...h of mask Usage Parameters start and length must be in the range from 0 to 31 Bit functions operate on 32 bit integers Examples This example shows BitMaskClear HTML HEAD TITLE BitMaskClear Example TIT...

Страница 307: ...the length of mask Usage Parameters start and length must be in the range from 0 to 31 Bit functions operate on 32 bit integers Examples This example shows BitMaskRead HTML HEAD TITLE BitMaskRead Exa...

Страница 308: ...nteger specifying the length of mask Usage Parameters start and length must be in the range from 0 to 31 Bit functions operate on 32 bit integers Examples This example shows BitMaskSet HTML HEAD TITLE...

Страница 309: ...x BitNot number number Any long integer Usage Bit functions operate on 32 bit integers Examples This example shows BitNot HTML HEAD TITLE BitNot Example TITLE HEAD BODY H3 BitNot Example H3 Returns th...

Страница 310: ...mber2 Any long integers Usage Bit functions operate on 32 bit integers Examples This example shows BitOr HTML HEAD TITLE BitOr Example TITLE HEAD BODY H3 BitOr Example H3 Returns the bitwise OR of two...

Страница 311: ...d Usage Parameter count must be in the range from 0 to 31 Bit functions operate on 32 bit integers Examples This example shows BitSHLN HTML HEAD TITLE BitSHLN Example TITLE HEAD BODY H3 BitSHLN Exampl...

Страница 312: ...be shifted Usage Parameter count must be in the range from 0 to 31 Bit functions operate on 32 bit integers Examples This example shows BitSHRN HTML HEAD TITLE BitSHRN Example TITLE HEAD BODY H3 BitS...

Страница 313: ...Any long integers Usage Bit functions operate on 32 bit integers Examples This example shows BitXOr HTML HEAD TITLE BitXOr Example TITLE HEAD BODY H3 BitXOr Example H3 Returns the bitwise XOR of two...

Страница 314: ...er number Any real number Examples This example illustrates the CF function ceiling HTML HEAD TITLE Ceiling Example TITLE HEAD BODY BGCOLOR silver H3 Ceiling Example H3 CFOUTPUT P The ceiling of 3 4 i...

Страница 315: ...ne string Examples This code illustrates CHR HTML HEAD TITLE CHR Example TITLE HEAD BODY BGCOLOR silver H3 CHR Example H3 if the character string is not empty then output its CHR value CFIF IsDefined...

Страница 316: ...stify CFPARAM NAME jstring DEFAULT CFIF IsDefined FORM justifyString CFSET jstring Cjustify FORM justifyString 35 CFIF HTML HEAD TITLE CJustify Example TITLE HEAD BODY BGCOLOR silver H3 CJustify H3 P...

Страница 317: ...tion they appear listed in dictionary order Examples This example shows the use of Compare HTML HEAD TITLE Compare Example TITLE HEAD BODY BGCOLOR silver H3 Compare Example H3 P The compare function p...

Страница 318: ...ce CFSWITCH CFIF FORM ACTION compare cfm METHOD POST P String 1 BR INPUT TYPE Text NAME string1 P String 2 BR INPUT TYPE Text NAME string2 P INPUT TYPE Submit VALUE Compare these Strings NAME INPUT TY...

Страница 319: ...reNoCase Example TITLE HEAD BODY BGCOLOR silver H3 CompareNoCase Example H3 P The compare function performs a I case insensitive I comparison of two strings CFIF IsDefined FORM string1 CFSET compariso...

Страница 320: ...Cos HTML HEAD TITLE Cos Example TITLE HEAD BODY BGCOLOR silver H3 Cos Example H3 output its Cos value CFIF IsDefined FORM CosNum CFIF IsNumeric FORM CosNum Cos CFOUTPUT FORM CosNum CFOUTPUT CFOUTPUT C...

Страница 321: ...December day Number representing the day of the month ranging from 1 to 31 Usage CreateDate is a subset of CreateDateTime Time in the returned object is set to 00 00 00 Examples This example shows how...

Страница 322: ...year FORM month FORM day 12 13 0 LI Built with CreateODBCDate DateFormat CreateODBCDate yourDate mmmm d yyyy LI Built with CreateODBCDateTime DateFormat CreateODBCDateTime yourDate d m yy UL CFOUTPUT...

Страница 323: ...to 23 minute Number representing the minute ranging from 0 to 59 second Number representing the second ranging from 0 to 59 Usage Years from 0 to 29 are interpreted as 21st century values Years 30 to...

Страница 324: ...createdatetime cfm METHOD POST P Please enter the year month and day in integer format for the date value you would like to view PRE Year CFINPUT TYPE Text NAME year VALUE 1998 VALIDATE integer REQUI...

Страница 325: ...the type parameter there are several additional parameters you can use This table shows which parameters you can use with each object type Sections that follow describe these values and parameters in...

Страница 326: ...name using UNC Universal Naming Convention or DNS Domain Name Server conventions in one of the following forms SERVER lanserver SERVER lanserver SERVER http www servername com SERVER www servername co...

Страница 327: ...and method signatures User defined types for example structures are not supported JAVA CFOBJECT allows you to create and use JAVA objects and by extension EJB objects This support is currently only fo...

Страница 328: ...e conversions when strings are passed as arguments but not when they are received as return values Overloaded methods are supported as long as the number of arguments are different Future enhancements...

Страница 329: ...face Arial Helvetica size 2 body bgcolor FFFFD5 H3 CreateODBCDate Example H3 CFIF IsDefined FORM year Your date value presented using different CF date functions CFSET yourDate CreateDateTime FORM yea...

Страница 330: ...year VALUE 1998 VALIDATE integer REQUIRED Yes Month CFINPUT TYPE Text NAME month VALUE 6 RANGE 1 12 MESSAGE Please enter a month 1 12 VALIDATE integer REQUIRED Yes Day CFINPUT TYPE Text NAME day VALUE...

Страница 331: ...use CreateDate CreateDateTime and createODBCDateTime HTML HEAD TITLE CreateODBCDateTime Example TITLE HEAD BODY BGCOLOR silver H3 CreateODBCDateTime Example H3 CFIF IsDefined FORM year Your date value...

Страница 332: ...IDATE integer REQUIRED Yes Month CFINPUT TYPE Text NAME month VALUE 6 RANGE 1 12 MESSAGE Please enter a month 1 12 VALIDATE integer REQUIRED Yes Day CFINPUT TYPE Text NAME day VALUE 8 RANGE 1 31 MESSA...

Страница 333: ...AD BODY BGCOLOR silver H3 CreateODBCTime Example H3 CFIF IsDefined FORM hour Your time value presented using different CF time functions CFSET yourTime CreateTime FORM hour FORM minute FORM second CFO...

Страница 334: ...a minute value 0 59 VALIDATE integer REQUIRED Yes Second CFINPUT TYPE Text NAME second VALUE 0 RANGE 0 59 MESSAGE You must enter a value for seconds 0 59 VALIDATE integer REQUIRED Yes PRE P INPUT TYP...

Страница 335: ...time variable is set to December 30 1899 Examples This code illustrates CreateTime and CreateODBCTime HTML HEAD TITLE CreateTime Example TITLE HEAD basefont face Arial Helvetica size 2 body bgcolor F...

Страница 336: ...312 CFMLLanguageReference CFIF BODY HTML...

Страница 337: ...nly be used to add and subtract from other date time objects or with the CFQUERY CACHEDWITHIN attribute Examples This example shows how to CreateTimeSpan CFIF IsDefined FORM year set variables for the...

Страница 338: ...such as DCE RPC COM and CORBA With ColdFusion you can use UUIDs as primary table keys for applications where data is stored on a number of shared databases In such cases using numeric keys may cause...

Страница 339: ...ates in the past date Date time object in the period from 100 AD to 9999 AD Years from 0 to 29 are interpreted as 21st century values Years 30 to 99 are interpreted as 20th century values Usage The da...

Страница 340: ...CASE VALUE m months CFCASE CFCASE VALUE y days of year CFCASE CFCASE VALUE w weekdays CFCASE CFCASE VALUE ww weeks CFCASE CFCASE VALUE h hours CFCASE CFCASE VALUE n minutes CFCASE CFCASE VALUE s secon...

Страница 341: ...The precision of the comparison This parameter can have any of the following values s precise to the second n precise to the minute h precise to the hour d precise to the day m precise to the month yy...

Страница 342: ...CASE CFCASE VALUE 0 H3 CFOUTPUT DateFormat FORM date1 TimeFormat FORM date1 CFOUTPUT Date 1 is equal to CFOUTPUT DateFormat FORM date2 TimeFormat FORM date2 CFOUTPUT Date 2 H3 I The dates are equal I...

Страница 343: ...PUT P Specify precision to the BR select NAME precision option VALUE s Second OPTION option VALUE n Minute OPTION option VALUE h Hour OPTION option VALUE d Day OPTION option VALUE m Month OPTION optio...

Страница 344: ...When passing a date time value as a string make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning undesired results Examples This ex...

Страница 345: ...POST P Please enter the year month and day in integer format for the date value you would like to view table cellspacing 2 cellpadding 2 border 0 tr td Year td td INPUT TYPE Text NAME year VALUE 1998...

Страница 346: ...d INPUT TYPE Text NAME second VALUE 0 RANGE 0 59 MESSAGE You must enter a value for seconds 0 59 VALIDATE integer REQUIRED Yes td tr tr td INPUT TYPE Submit NAME submit VALUE Submit td td INPUT TYPE R...

Страница 347: ...f Year y or Day d When datepart is Weekday w DateDiff returns the number of weeks between the two dates If date1 falls on a Monday DateDiff counts the number of Mondays until date2 It counts date2 but...

Страница 348: ...ASE VALUE w weekdays CFCASE CFCASE VALUE ww weeks CFCASE CFCASE VALUE h hours CFCASE CFCASE VALUE n minutes CFCASE CFCASE VALUE s seconds CFCASE CFDEFAULTCASE years CFDEFAULTCASE CFSWITCH dateparts be...

Страница 349: ...ding zero for years less than 10 yy Year as last two digits with a leading zero for years less than 10 yyyy Year represented by four digits gg Period era string Currently ignored but reserved for futu...

Страница 350: ...le H3 P Today s date is CFOUTPUT todayDate CFOUTPUT P Using DateFormat we can display that date in a number of different ways CFOUTPUT UL LI DateFormat todayDate LI DateFormat todayDate mmm dd yyyy LI...

Страница 351: ...sage Years from 0 to 29 are interpreted as 21st century values Years 30 to 99 are interpreted as 20th century values When passing a date time value as a string make sure it is enclosed in quotes Other...

Страница 352: ...LI year DatePart yyyy todayDate LI quarter DatePart q todayDate LI month DatePart m todayDate LI day of year DatePart y todayDate LI day DatePart d todayDate LI weekday DatePart w todayDate LI week Da...

Страница 353: ...rning undesired results Examples This example shows the value of the Day function HTML HEAD TITLE Day Example TITLE HEAD BODY BGCOLOR silver H3 Day Example H3 CFIF IsDefined FORM year More information...

Страница 354: ...object returning undesired results Examples This example shows the value of the DayOfWeek function HTML HEAD TITLE DayofWeek Example TITLE HEAD BODY BGCOLOR silver H3 DayOfWeek Example H3 CFIF IsDefi...

Страница 355: ...hows the value of the dayOfWeekAsString function HTML HEAD TITLE DayOfWeekAsString Example TITLE HEAD BODY BGCOLOR silver H3 DayOfWeekAsString Example H3 CFIF IsDefined FORM year More information abou...

Страница 356: ...returning undesired results Examples shows the value of the DayOfYear function HTML HEAD TITLE DayOfYear Example TITLE HEAD BODY BGCOLOR silver H3 DayOfYear Example H3 CFIF IsDefined FORM year More in...

Страница 357: ...g undesired results Examples shows the value of the DaysInMonth function HTML HEAD TITLE DaysInMonth Example TITLE HEAD BODY BGCOLOR silver H3 DaysInMonth Example H3 CFIF IsDefined FORM year More info...

Страница 358: ...preted as a number representation of a date time object returning undesired results Examples shows the value of the DaysInYear function HTML HEAD TITLE DaysInYear Example TITLE HEAD BODY BGCOLOR silve...

Страница 359: ...E DE Example TITLE HEAD BODY BGCOLOR silver H3 DE Example H3 CFIF IsDefined FORM myExpression H3 The Expression Result H3 CFTRY Evaluate the expression CFSET myExpression Evaluate FORM myExpression Us...

Страница 360: ...cimalFormat number number Number being formatted Examples This code shows the use of DecimalFormat HTML HEAD TITLE DecimalFormat Example TITLE HEAD BODY BGCOLOR silver H3 DecimalFormat Function H3 P R...

Страница 361: ...emented Examples This shows the use of DecrementValue HTML HEAD TITLE DecrementValue Example TITLE HEAD BODY H3 DecrementValue Example H3 P Returns the integer part of a number decremented by one P De...

Страница 362: ...own string and a key of your own choosing and seeing the results CFIF IsDefined FORM myString CFSET string FORM myString CFSET key FORM myKey CFSET encrypted encrypt string key CFSET decrypted decrypt...

Страница 363: ...TML HEAD TITLE DeleteClientVariable Example TITLE HEAD BODY this example is view only H3 DeleteClientVariable Example H3 P This view only example deletes a client variable called User_ID if it exists...

Страница 364: ...oryExists Example TITLE HEAD BODY BGCOLOR silver H3 DirectoryExists Example H3 CFSET thisPath ExpandPath CFSET thisDirectory GetDirectoryFromPath thisPath CFSET thisDirectory Left thisDirectory Evalua...

Страница 365: ...ML HEAD TITLE DollarFormat Example TITLE HEAD BODY BGCOLOR silver H3 DollarFormat Example H3 CFLOOP from 8 to 50 index counter CFSET full counter CFSET quarter Evaluate counter 1 4 CFSET half Evaluate...

Страница 366: ...of your own choosing and seeing the results CFIF IsDefined FORM myString CFSET string FORM myString CFSET key FORM myKey CFSET encrypted encrypt string key CFSET decrypted decrypt encrypted key CFOUTP...

Страница 367: ...more complicated to write because they are inside a string In particular if the string expression is double quoted double quotes inside the expression must be escaped Examples This shows the use of D...

Страница 368: ...ber BR FORM number raised to the E power exp FORM number CFIF FORM number LTE 0 BR You must enter a positive real number to see the natural logarithm of that number CFELSE BR The natural logarithm of...

Страница 369: ...h ExpandPath converts relative directory references and to an absolute path The function throws an error if this argument or the resulting absolute path is invalid Examples This example shows the use...

Страница 370: ...of FileExists HTML HEAD TITLE FileExists Example TITLE HEAD BODY BGCOLOR silver H3 FileExists Example H3 CFSET thisPath ExpandPath CFSET thisDirectory GetDirectoryFromPath thisPath CFOUTPUT The curre...

Страница 371: ...sought string String being searched start Starting position for the search Examples depending upon the action desired perform different function CFSWITCH EXPRESSION tag CFCASE VALUE find CFSET TheActi...

Страница 372: ...g being sought string String being searched start Starting position for the search Examples depending upon the action desired perform different function CFSWITCH EXPRESSION tag CFCASE VALUE find CFSET...

Страница 373: ...t string String being searched start Starting position for the search Examples depending upon the action desired perform different function CFSWITCH EXPRESSION tag CFCASE VALUE find CFSET TheAction Fi...

Страница 374: ...erpreted as 20th century values When passing a date time value as a string make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning und...

Страница 375: ...ber number Any number Examples This example shows the use of Fix HTML HEAD TITLE Fix Example TITLE HEAD BODY H3 Fix Example H3 P Fix returns the closest integer less than the number if the number is g...

Страница 376: ...er to a string in the base specified by Radix P CFOUTPUT BR FormatBaseN 10 2 FormatBaseN 10 2 BR FormatBaseN 1024 16 FormatBaseN 1024 16 BR FormatBaseN 125 10 FormatBaseN 125 10 BR FormatBaseN 10 75 2...

Страница 377: ...Required Specifies the ancestor tag name for which the function returns data instancenumber Optional Specifies the number of ancestor levels to jump before returning data The default is 1 Example Thi...

Страница 378: ...example illustrates usage of the GetBaseTagList function This is typically used in custom tags CFIF thisTag executionMode is start Get the tag context stack The list will look something like CFIF MYTA...

Страница 379: ...ePath FileExists and ExpandPath Syntax GetBaseTemplatePath Example This example uses GetBaseTemplatePath to show the template path of the current page HTML HEAD TITLE GetBaseTemplatePath Example TITLE...

Страница 380: ...xample deletes a client variable called User_ID if it exists in the list of client variables returned by GetClientVariablesList P This example requires the existance of an Application cfm file and tha...

Страница 381: ...uded template if the call is made from a template included with a CFINCLUDE tag whereas GetBaseTemplatePath returns the template path of the top level template even when the call to GetBaseTemplatePat...

Страница 382: ...ath CFOUTPUT The current directory is GetDirectoryFromPath thisPath CFIF IsDefined FORM yourFile CFIF FORM yourFile is not CFSET yourFile FORM yourFile CFIF FileExists ExpandPath yourfile P Your file...

Страница 383: ...The current directory is GetDirectoryFromPath thisPath CFIF IsDefined FORM yourFile CFIF FORM yourFile is not CFSET yourFile FORM yourFile CFIF FileExists ExpandPath yourfile P Your file exists in thi...

Страница 384: ...ns that are available in ColdFusion Syntax GetFunctionList Examples The following code displays a list of ColdFusion functions CFSET fList GetFunctionList CFOUTPUT StructCount fList functions BR BR CF...

Страница 385: ...st of the locales that ColdFusion and the operating system support GetLocale will return an entry from that list SetLocale will fail if called with a locale name not on that list Example This example...

Страница 386: ...ned by the native operating system P A locale is an encapsulation of the set of attributes that govern the display and formatting of international date time number and currency values P The locale for...

Страница 387: ...Data monitor_name monitor_name The name of the performance monitor On Windows NT the performance monitor is PerfMonitor On UNIX it is CFStat Usage On Windows NT the function returns a ColdFusion struc...

Страница 388: ...pmData ReqRunning P ReqTimedOut pmData ReqTimedOut P BytesIn pmData BytesIn P BytesOut pmData BytesOut P AvgQueueTime pmData AvgQueueTime P AvgReqTime pmData AvgReqTime P AvgDBTime pmData AvgDBTime P...

Страница 389: ...ion The section of the initialization file from which you would like to extract information entry The name of the value that you would like to see Example This example uses GetProfileString to set the...

Страница 390: ...UT timeout CFOUTPUT P CFIF FORM ACTION getprofilestring cfm METHOD POST hr size 2 color 0000A0 table cellspacing 2 cellpadding 2 border 0 tr td Full Path of Init File td td INPUT TYPE Text NAME IniPat...

Страница 391: ...the directory it returns under your account See also GetTempFile Syntax GetTempDirectory Example This example uses GetTempDirectory to find the temporary directory and GetTempFile to place a dummy fil...

Страница 392: ...orary file to be created in the directory specified by dir Examples This example uses GetTempDirectory to find the temporary directory and GetTempFile to place a dummy file in that directory HTML HEAD...

Страница 393: ...d should be used in place of it in all code written after the release of ColdFusion 4 0 See also GetBaseTemplatePath FileExists and ExpandPath Syntax GetTemplatePath Example This example uses GetTempl...

Страница 394: ...s between the results of GetTickCount at specified points during page processing Examples This example calls the GetTickCount function to track execution time HTML BODY Setup timing test CFSET iterati...

Страница 395: ...will always be zero However for some countries that do not land exactly on the hour offset the number will be between 0 and 60 For example standard time in Adelaide Australia has an offset of 9 hours...

Страница 396: ...sets of delimiters Examples This example shows the use of GetToken HTML HEAD TITLE GetToken Example TITLE HEAD BODY BGCOLOR silver H3 GetToken Example H3 CFIF IsDefined FORM yourString set delimiter...

Страница 397: ...ury values When passing a date time value as a string make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning undesired results Exampl...

Страница 398: ...ML 3 2 Example This example shows the use of HTMLCodeFormat and HTMLEditFormat HTML HEAD TITLE HTMLCodeFormat Example TITLE HEAD BODY BGCOLOR silver H3 HTMLCodeFormat Example H3 FORM ACTION HTMLcodefo...

Страница 399: ...HTTP tag to get the file content represented by urladdress CFHTTP URL urladdress METHOD GET RESOLVEURL YES CFHTTP CFELSE the first time through retrieve a URL that we know exists CFHTTP URL http local...

Страница 400: ...d string This can cause unpredictable results when performing certain string functions Left Right and Mid for example against the expanded string Example This example shows the use of HTMLCodeFormat a...

Страница 401: ...Address FORM urladdress CFIF now use the CFHTTP tag to get the file content represented by urladdress CFHTTP URL urladdress METHOD GET RESOLVEURL YES CFHTTP CFELSE the first time through retrieve a UR...

Страница 402: ...ge The IIf function is a shortcut for the following construct CFIF condition CFSET result Evaluate string_expression1 CFELSE CFSET result Evaluate string_expression2 CFIF returning result The expressi...

Страница 403: ...the original condition IsDefined LocalVar CFOUTPUT IIf IsDefined LocalVar DE LocalVar DE The variable is not defined CFOUTPUT The error message would be Error resolving parameter LOCALVAR The DE funct...

Страница 404: ...380 CFMLLanguageReference DE It is morning CFOUTPUT P BODY HTML...

Страница 405: ...emented Examples This shows the use of IncrementValue HTML HEAD TITLE IncrementValue Example TITLE HEAD BODY H3 IncrementValue Example H3 P Returns the integer part of a number Incremented by one P In...

Страница 406: ...AD BODY H3 InputBaseN Example H3 P FormatBaseN converts a number to a string in the base specified by Radix P CFOUTPUT BR FormatBaseN 10 2 FormatBaseN 10 2 BR FormatBaseN 1024 16 FormatBaseN 1024 16 B...

Страница 407: ...s This example shows the use of Insert HTML HEAD TITLE Insert Example TITLE HEAD BODY BGCOLOR silver H3 Insert Example H3 CFIF IsDefined FORM myString if the position is longer than the length of the...

Страница 408: ...l number you want to round down to an integer Examples This example shows the use of Int HTML HEAD TITLE Int Example TITLE HEAD BODY BGCOLOR silver H3 Int Example H3 P Int returns the closest integer...

Страница 409: ...d dimension Examples This example shows IsArray HTML HEAD TITLE IsArray Example TITLE HEAD BODY H3 IsArray Example H3 Make an array CFSET MyNewArray ArrayNew 1 set some elements CFSET MyNewArray 1 ele...

Страница 410: ...Syntax IsAuthenticated security context name security context name The security context name Example This example calls the IsAuthenticated function This code is from an Application cfm file CFIF NOT...

Страница 411: ...tion CustomTag UserObject resourcename String specifying the name of the resource The value specified varies depending on the resource type Resourcename is the actual resource that is protected not to...

Страница 412: ...d to select information from the Orders data source CFIF IsAuthorized DATASOURCE Orders select CFQUERY NAME GetList datasource Orders SELECT FROM Orders CFQUERY CFOUTPUT QUERY GetList Authorization Su...

Страница 413: ...Chapter 2 ColdFusion Functions 389 Customer BalanceDue BR CFOUTPUT CFIF BODY HTML...

Страница 414: ...has passed this page the value of the variable data_var which can hold either character data or binary data This example checks to see whether data_var is binary and if it is it converts the binary da...

Страница 415: ...D BODY BGCOLOR silver H3 IsBoolean Example H3 CFIF IsDefined FORM theTestValue CFIF IsBoolean FORM theTestValue H3 The expression CFOUTPUT DE FORM theTestValue CFOUTPUT is Boolean H3 CFELSE H3 The exp...

Страница 416: ...0th century values Examples This example shows the use of IsDate HTML HEAD TITLE IsDate Example TITLE HEAD BODY BGCOLOR silver H3 IsDate Example H3 CFIF IsDefined FORM theTestValue CFIF IsDate FORM th...

Страница 417: ...LSE if debugging mode is disabled Syntax IsDebugMode Examples This example shows the use of IsDebugMode HTML HEAD TITLE IsDebugMode Example TITLE HEAD BODY BGCOLOR silver H3 IsDebugMode Example H3 CFI...

Страница 418: ...want to test for This value must always be enclosed in quotation marks Example This example shows the use of IsDefined HTML HEAD TITLE IsDefined Example TITLE HEAD BODY BGCOLOR silver H3 IsDefined Ex...

Страница 419: ...H3 IsLeapYear Example H3 CFIF IsDefined FORM theTestValue CFIF IsLeapYear FORM theTestValue H3 The year value CFOUTPUT DE FORM theTestValue CFOUTPUT is a Leap Year H3 CFELSE H3 The year value CFOUTPU...

Страница 420: ...Numeric Example H3 CFIF IsDefined FORM theTestValue CFIF IsNumeric FORM theTestValue H3 The string CFOUTPUT DE FORM theTestValue CFOUTPUT can be converted to a number H3 CFELSE H3 The string CFOUTPUT...

Страница 421: ...re formatted Date value CFIF IsNumeric FORM theTestValue or IsDate FORM theTestValue if this value is a numericDate value then pass CFIF IsNumericDate FORM theTestValue H3 The string CFOUTPUT DE FORM...

Страница 422: ...bject resourcename String specifying the name of the resource Resourcename is the actual resource that is protected not to be confused with the rule name which you specify in the ColdFusion Administra...

Страница 423: ...f a resource is explicitly protected with a rule you must use the IsProtected function Example This example calls the IsProtected function The following code checks to see if the Orders data source is...

Страница 424: ...IsAuthorized DATASOURCE Orders select CFQUERY NAME GetList datasource Orders SELECT FROM Orders CFQUERY CFOUTPUT QUERY GetList Authorization Succeeded Order information follows Customer BalanceDue BR...

Страница 425: ...query is run the value of GetEmployees is CFOUTPUT getEmployees CFOUTPUT CFIF IsSimpleValue getEmployees P getEmployees is currently a simple value CFIF make a query on the snippets datasource RY NAME...

Страница 426: ...ow P Before the query is run the value of GetEmployees is CFOUTPUT getEmployees CFOUTPUT CFIF IsSimpleValue getEmployees P getEmployees is currently a simple value CFIF make a query on the snippets da...

Страница 427: ...ployee structure the EMPINFO attribute In UNIX you must also add the Emp_ID CFSWITCH EXPRESSION ThisTag ExecutionMode CFCASE VALUE start CFIF IsStruct attributes EMPINFO CFOUTPUT Error Invalid data CF...

Страница 428: ...ly into JavaScript Examples This example illustrates use of the JSStringFormat function HTML HEAD TITLE JSStringFormat TITLE HEAD BODY H3 JSStringFormat H3 CFSET stringValue An example string value wi...

Страница 429: ...OR silver H3 LCase Example H3 CFIF IsDefined FORM sampleText CFIF FORM sampleText is not P Your text CFOUTPUT FORM sampleText CFOUTPUT returned in lowercase is CFOUTPUT LCase FORM sampleText CFOUTPUT...

Страница 430: ...ple H3 CFIF IsDefined Form MyText if len is 0 then err CFIF Len FORM myText is not 0 CFIF Len FORM myText LTE FORM RemoveChars P Your string CFOUTPUT FORM myText CFOUTPUT only has CFOUTPUT Len FORM my...

Страница 431: ...le TITLE HEAD BODY BGCOLOR silver H3 Len Example H3 CFIF IsDefined Form MyText if len is 0 then err CFIF Len FORM myText is not 0 P Your string CFOUTPUT FORM myText CFOUTPUT has CFOUTPUT Len FORM myTe...

Страница 432: ...s on strings that are delimited by the conjunction comma space as is common in HTTP header strings such as the COOKIE header we recommend that you specify delimiters to include both comma and space be...

Страница 433: ...ple shows ListChangeDelims HTML HEAD TITLE ListChangeDelims Example TITLE HEAD BODY H3 ListChangeDelims Example H3 P ListChangeDelims allows you to change the delimiters used in a list First query to...

Страница 434: ...ind HTML HEAD TITLE ListContains TITLE HEAD BODY Create a list composed of the items one two three CFSET aList one CFSET aList ListAppend aList two CFSET aList ListAppend aList three P Here is the lis...

Страница 435: ...B both ListContains and ListFind will find it in the second item in the list BR ListContains BR CFOUTPUT The string two is in b Item ListContains aList two b of the list CFOUTPUT BR ListFind BR CFOUT...

Страница 436: ...rs Set of delimiters used in list Examples This example shows ListContainsNoCase HTML HEAD TITLE ListContainsNoCase Example TITLE HEAD BODY BGCOLOR silver H3 ListContainsNoCase Example H3 CFIF IsDefin...

Страница 437: ...This example shows ListDeleteAt HTML HEAD TITLE ListDeleteAt Example TITLE HEAD BODY H3 ListDeleteAt Example H3 First query to get some values for our list CFQUERY NAME GetParkInfo DATASOURCE cfsnippe...

Страница 438: ...LE ListFind TITLE HEAD BODY Create a list composed of the items one two three CFSET aList one CFSET aList ListAppend aList two CFSET aList ListAppend aList three P Here is the list B CFOUTPUT aList CF...

Страница 439: ...B both ListContains and ListFind will find it in the second item in the list BR ListContains BR CFOUTPUT The string two is in b Item ListContains aList two b of the list CFOUTPUT BR ListFind BR CFOUT...

Страница 440: ...s example uses ListFind and ListFindNoCase to see if a substring exists in a list CFSET temp ListFindNoCase myList FORM myString CFIF temp is 0 H3 An employee with that exact last name was not found H...

Страница 441: ...TML HEAD TITLE ListFirst Example TITLE HEAD BODY H3 ListFirst Example H3 Find a list of users who wrote messages CFQUERY NAME GetMessageUser DATASOURCE cfsnippets SELECT Username Subject Posted FROM M...

Страница 442: ...r 1 not 0 Examples This example shows ListGetAt and ListLen HTML HEAD TITLE ListGetAt Example TITLE HEAD BODY H3 ListGetAt Example H3 Find a list of users who wrote messages CFQUERY NAME GetMessageUse...

Страница 443: ...o the first delimiter in the string or comma if delimiters was omitted If you intend to use list functions on strings that are delimited by the conjunction comma space as is common in HTTP header stri...

Страница 444: ...TLE ListLast Example TITLE HEAD BODY H3 ListLast Example H3 Find a list of users who wrote messages CFQUERY NAME GetMessageUser DATASOURCE cfsnippets SELECT Username Subject Posted FROM Messages CFQUE...

Страница 445: ...Example TITLE HEAD BODY H3 ListLen Example H3 Find a list of users who wrote messages CFQUERY NAME GetMessageUser DATASOURCE cfsnippets SELECT Username Subject Posted FROM Messages CFQUERY CFSET temp...

Страница 446: ...ma if delimiters was omitted If you intend to use list functions on strings that are delimited by the conjunction comma space as is common in HTTP header strings such as the COOKIE header we recommend...

Страница 447: ...f you specify CHAR the function qualifiers only items comprised of alphabetic characters it does not qualify numeric items Usage The new list may not preserve all of the delimiters in the previous lis...

Страница 448: ...le quotes around each full name CFSET qualifiedList1 ListQualify myList CHAR output the array as a list CFOUTPUT P The contents of the qualified list are as follows P P qualifiedList1 P CFOUTPUT show...

Страница 449: ...First ListLast and ListRest HTML HEAD TITLE ListRest Example TITLE HEAD BODY H3 ListRest Example H3 Find a list of users who wrote messages CFQUERY NAME GetMessageUser DATASOURCE cfsnippets SELECT Use...

Страница 450: ...omitted If you intend to use list functions on strings that are delimited by the conjunction comma space as is common in HTTP header strings such as the COOKIE header we recommend that you specify del...

Страница 451: ...I changed this subject UL CFLOOP From 1 To ListLen temptoo INDEX Counter CFOUTPUT LI Counter SUBJECT ListGetAt temptoo Counter CFOUTPUT CFLOOP UL P Note that item 2 CFOUTPUT changedItem CFOUTPUT has...

Страница 452: ...red sort_order The order to be followed You can specify any of the following Asc Default Ascending sort order Desc Descending sort order delimiter Specify the character s used to delimit elements in t...

Страница 453: ...a list that must be sorted numerically since it contains both negative and positive numbers as well as decimal numbers P CFSET sortedNums2 ListSort 23 75 34 471 100 9745 Numeric ASC CFOUTPUT sortedNu...

Страница 454: ...e character s used to delimit elements in the list Default is comma Example This example shows ListToArray HTML HEAD TITLE ListToArray Example TITLE HEAD BODY H3 ListToArray Example H3 Find a list of...

Страница 455: ...he list The default is a comma Example This example uses ListValueCount to see how many employees are in a department HTML HEAD TITLE ListValueCount Example TITLE HEAD body bgcolor FFFFD5 CFQUERY NAME...

Страница 456: ...ist ValueList SearchByDepartment Department CFSET numberInDepartment ListValueCount myList FORM departmentName CFIF numberInDepartment is 0 H3 There are no employees in CFOUTPUT FORM departmentName CF...

Страница 457: ...e default is a comma Example This example uses ListValueCountNoCase to see how many employees are in a department HTML HEAD TITLE ListValueCountNoCase Example TITLE HEAD body bgcolor FFFFD5 CFQUERY NA...

Страница 458: ...ist ValueList SearchByDepartment Department CFSET numberInDepartment ListValueCountNoCase myList FORM departmentName CFIF numberInDepartment is 0 H3 There are no employees in CFOUTPUT FORM departmentN...

Страница 459: ...use LJustify CFPARAM NAME jstring DEFAULT CFIF IsDefined FORM justifyString CFSET jstring Ljustify FORM justifyString 35 CFIF HTML HEAD TITLE LJustify Example TITLE HEAD BODY BGCOLOR silver H3 LJusti...

Страница 460: ...number CFIF FORM number LTE 0 BR You must enter a positive real number to see the natural logarithm of that number CFELSE BR The natural logarithm of FORM number log FORM number CFIF CFIF FORM number...

Страница 461: ...0 BR You must enter a positive real number to see the natural logarithm of that number CFELSE BR The natural logarithm of FORM number log FORM number CFIF CFIF FORM number LTE 0 BR You must enter a po...

Страница 462: ...ut for some of the locales supported by ColdFusion in each of the format types local international and none Locale Format Type Output Dutch Belgian Local 100 000 00 BF International BEF100 000 00 None...

Страница 463: ...000 00 German Standard Local 100 000 00 DM International DEM100 000 00 None 100 000 00 German Swiss Local SFr 100 000 00 International CHF100 000 00 None 100 000 00 Italian Standard Local L 10 000 00...

Страница 464: ...DELIMITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR Local LSCurrencyFormat 100000 local BR International LSCurrencyFormat 100000 international BR None LSCurrencyFormat 100000 none...

Страница 465: ...f the week as its full name m Month as digits with no leading zero for single digit months mm Month as digits with a leading zero for single digit months mmm Month as a three letter abbreviation mmmm...

Страница 466: ...ales INDEX locale DELIMITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR LSDateFormat Now mmm dd yyyy BR LSDateFormat Now mmmm d yyyy BR LSDateFormat Now mm dd yyyy BR LSDateFormat N...

Страница 467: ...y the Euro symbol only on Euro enabled computers such as Windows NT 4 0 SP4 that have Euro enabled fonts installed This function is similar to LSCurrencyFormat except that LSEuroCurrencyFormat display...

Страница 468: ...International EUR100 000 00 None 100 000 00 French Canadian Local 100 000 00 International EUR100 000 00 None 100 000 00 French Standard Local 100 000 00 International EUR100 000 00 None 100 000 00 F...

Страница 469: ...000 00 International EUR100 000 00 None 100 000 00 Norwegian Nynorsk Local 100 000 00 International EUR100 000 00 None 100 000 00 Portuguese Brazilian Local 100 000 00 International EUR100 000 00 None...

Страница 470: ...les INDEX locale DELIMITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR Local LSEuroCurrencyFormat 100000 local BR International LSEuroCurrencyFormat 100000 international BR None LSE...

Страница 471: ...mple TITLE HEAD BODY BGCOLOR silver H3 LSIsCurrency Example H3 CFIF IsDefined FORM locale if locale is defined set locale to that entry CFSET NewLocale SetLocale FORM locale P Is the value CFOUTPUT FO...

Страница 472: ...TML HEAD TITLE LSIsDate Example TITLE HEAD BODY BGCOLOR silver H3 LSIsDate Example H3 CFIF IsDefined FORM locale if locale is defined set locale to that entry CFSET NewLocale SetLocale FORM locale P I...

Страница 473: ...ML HEAD TITLE LSIsNumeric Example TITLE HEAD BODY BGCOLOR silver H3 LSIsNumeric Example H3 CFIF IsDefined FORM locale if locale is defined set locale to that entry CFSET NewLocale SetLocale FORM local...

Страница 474: ...9 Optional digit placeholder Same as _ but shows decimal places more clearly Specifies the location of a mandatory decimal point 0 Located to the left or right of a mandatory decimal point to force p...

Страница 475: ...cters This positioning idea can also be used to show where to place the minus sign for negative numbers There are four possible positions for any code character far left near left near right and far r...

Страница 476: ...DEX locale DELIMITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR LSNumberFormat 1234 5678 _________ BR LSNumberFormat 1234 5678 _________ ___ BR LSNumberFormat 1234 5678 _________ B...

Страница 477: ...cales supported by ColdFusion in each of the format types local international and none Currency Output by Locale Locale Format Type Output Dutch Belgian Local 100 000 00 BF International BEF100 000 00...

Страница 478: ...onal DEM100 000 00 None 100 000 00 German Swiss Local SFr 100 000 00 International CHF100 000 00 None 100 000 00 Italian Standard Local L 10 000 000 International ITL10 000 000 None 10 000 000 Italian...

Страница 479: ...T oldlocale SetLocale locale CFOUTPUT P B I locale I B BR Local LSCurrencyFormat 123456 local BR Currency Number LSParseCurrency LSCurrencyFormat 123456 local BR International LSCurrencyFormat 123456...

Страница 480: ...a year in the date you should specify the full year If the date is formatted for a locale other than the English US locale add or subtract the conversion time depending on the locale LSParseDateTime...

Страница 481: ...locale I B BR P Locale specific formats BR LSDateFormat Now mmm dd yyyy LSTimeFormat Now BR LSDateFormat Now mmmm d yyyy LSTimeFormat Now BR LSDateFormat Now mm dd yyyy LSTimeFormat Now BR LSDateForm...

Страница 482: ...t that LSParseEuroCurrency parses only the Euro currency symbol or the international Euro sign EUR not other currency symbols such as the dollar sign or the pound sign Example This example shows LSPar...

Страница 483: ...Chapter 2 ColdFusion Functions 459 CFOUTPUT CFLOOP BODY HTML...

Страница 484: ...op through a list of possible locales and show number values CFLOOP LIST Server Coldfusion SupportedLocales INDEX locale DELIMITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR LSNumb...

Страница 485: ...g zero for single digit minutes mm Minutes with a leading zero for single digit minutes s Seconds with no leading zero for single digit seconds ss Seconds with a leading zero for single digit seconds...

Страница 486: ...ITERS CFSET oldlocale SetLocale locale CFOUTPUT P B I locale I B BR LSTimeFormat Now BR LSTimeFormat Now hh mm ss BR LSTimeFormat Now hh mm sst BR LSTimeFormat Now hh mm sstt BR LSTimeFormat Now HH mm...

Страница 487: ...TML HEAD TITLE LTrim Example TITLE HEAD BODY BGCOLOR silver H3 LTrim Example H3 CFIF IsDefined FORM myText CFOUTPUT PRE Your string FORM myText Your string Ltrim FORM myText left trimmed PRE CFOUTPUT...

Страница 488: ...um1 CFIF IsNumeric FORM myNum1 and IsNumeric FORM myNum2 P The maximum of the two numbers is CFOUTPUT Max FORM myNum1 FORM myNum2 CFOUTPUT P The minimum of the two numbers is CFOUTPUT Min FORM myNum1...

Страница 489: ...ple H3 CFIF IsDefined Form MyText if len is 0 then err CFIF Len FORM myText is not 0 CFIF Len FORM myText LTE FORM RemoveChars P Your string CFOUTPUT FORM myText cFOUTPUT only has CFOUTPUT Len FORM my...

Страница 490: ...Num1 CFIF IsNumeric FORM myNum1 and IsNumeric FORM myNum2 P The maximum of the two numbers is CFOUTPUT Max FORM myNum1 FORM myNum2 CFOUTPUT P The minimum of the two numbers is CFOUTPUT Min FORM myNum1...

Страница 491: ...values When passing a date time value as a string make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning undesired results Examples...

Страница 492: ...sults Examples shows the value of the Month function HTML HEAD TITLE Month Example TITLE HEAD BODY BGCOLOR silver H3 Month Example H3 CFIF IsDefined FORM year More information about your date CFSET yo...

Страница 493: ...tring Example H3 CFIF IsDefined FORM year More information about your date CFSET yourDate CreateDate FORM year FORM month FORM day CFOUTPUT P Your date DateFormat yourDate BR It is DayofWeekAsString D...

Страница 494: ...Part Syntax Now Examples This example shows Now HTML HEAD TITLE Now Example TITLE HEAD BODY H3 Now Example H3 P Now returns the current date and time as a valid date time object P The current date tim...

Страница 495: ...re clearly Specifies the location of a mandatory decimal point 0 Located to the left or right of a mandatory decimal point to force padding with zeros Places parentheses around the mask if the number...

Страница 496: ...n just to the left of the digits in the formatted number In all examples below the numbers under the masks and the formatted output are used to clearly show the positions of characters This positionin...

Страница 497: ...H3 NumberFormat Example H3 CFLOOP FROM 1000 TO 1020 INDEX counter CFSET CounterRoot2 Evaluate counter sqr 2 Show the result in default format adding the comma for the thousands place and also in custo...

Страница 498: ...Example TITLE HEAD BODY BGCOLOR silver H3 ParagraphFormat Example H3 P Enter some text into this textarea and see it returned as HTML CFIF IsDefined FORM myTextArea P Your text area formatted P CFOUT...

Страница 499: ...Y BGCOLOR silver H3 ParameterExists Example H3 CFIF ParameterExists FORM myString P Using ParameterExists we have shown that the FORM field myString now exists However this function is provided for ba...

Страница 500: ...values Both ParseDateTime and CreateDateTime are provided primarily to increase the readability of code in compound expressions Years from 0 to 29 are interpreted as 21st century values Years 30 to 99...

Страница 501: ...ter 2 ColdFusion Functions 477 H3 The expression CFOUTPUT DE FORM theTestValue CFOUTPUT is a valid date H3 P The date parsed for use as a date time value CFOUTPUT ParseDateTime FORM theTestValue CFOUT...

Страница 502: ...t accurate to 15 digits See also ASin Cos Sin and Tan Syntax Pi Examples This shows the use of Pi HTML HEAD TITLE Pi Example TITLE HEAD BODY H3 Pi Example H3 Returns the number CFOUTPUT NumberFormat P...

Страница 503: ...erveSingleQuotes Example H3 P This is a useful function for creating lists of information to return from a query In the following example we pick the list of Centers in Suisun San Francisco and San Di...

Страница 504: ...interpreted as 20th century values When passing a date time value as a string make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning...

Страница 505: ...ou can add columns to any type of query object such as queries retrieved with CFQUERY or queries created with QueryNew The only type of query that you cannot use QueryAddColumn on is a cached query Th...

Страница 506: ...add a second column to the query CFSET nColumnNumber2 QueryAddColumn myQuery FineCuisine FineCuisineArray create a third array CFSET HealthFoodArray ArrayNew 1 CFSET HealthFoodArray 1 Bean Curd CFSET...

Страница 507: ...TML HEAD TITLE QueryAddRow Example TITLE HEAD BODY H3 QueryAddRow Example H3 start by making a query CFQUERY NAME GetCourses DATASOURCE cfsnippets SELECT Course_ID Number Descript FROM Courses CFQUERY...

Страница 508: ...AD TITLE QueryNew Example TITLE HEAD BODY H3 QueryNew Example H3 P We will construct a new query with two rows CFSET myQuery QueryNew name address phone make some rows in the query CFSET newRow QueryA...

Страница 509: ...xample This example shows the use of QueryAddRow and QuerySetCell HTML HEAD TITLE QuerySetCell Example TITLE HEAD BODY H3 QuerySetCell Example H3 start by making a query CFQUERY NAME GetCourses DATASO...

Страница 510: ...erence Description of variable Countvar CFLOOP P After the QueryAddRow action the query has CFOUTPUT GetCourses RecordCount CFOUTPUT records CFOUTPUT query GetCourses PRE Course_ID Number Descript PRE...

Страница 511: ...EAD TITLE QuotedValueList Example TITLE HEAD BODY H3 QuotedValueList Example H3 use the contents of one query to create another dynamically CFSET List BIOL CHEM first get the department ids in our lis...

Страница 512: ...Usage To ensure even greater randomness call Randomize before calling Rand Example This example shows the use of Rand HTML HEAD TITLE Rand Example TITLE HEAD BODY BGCOLOR silver H3 Rand Example H3 P...

Страница 513: ...s This example shows the use of Randomize HTML HEAD TITLE Randomize Example TITLE HEAD BODY BGCOLOR silver H3 Randomize Example H3 P Call Randomize to seed the random number generator This helps to en...

Страница 514: ...Range Example TITLE HEAD BODY BGCOLOR silver H3 RandRange Example H3 P RandRange returns an integer between two specified integers CFIF IsDefined FORM myInt P RandRange returned CFOUTPUT RandRange FOR...

Страница 515: ...of the first substring that matches the criteria of the search You can retrieve the position and length of the matching subexpression by using the keys pos and len If there are no occurrences of the r...

Страница 516: ...a c abcaaccdd CFOUTPUT P P REFind upper abcaacCDD CFOUTPUT REFind upper abcaacCDD CFOUTPUT P P REFind rep report cfm rep 1234 u 5 CFOUTPUT REFind rep report cfm rep 1234 u 5 CFOUTPUT P Set startPos to...

Страница 517: ...the first element contains the position and length of the first instance of the whole expression The position and length of the first instance of each parenthesized subexpression within will be includ...

Страница 518: ...nt arrays containing the position and length of the first substring that matches the criteria of the search You can retrieve the position and length of the matching subexpression by using the keys pos...

Страница 519: ...EFindNoCase a c abcaaccdd CFOUTPUT P P REFindNoCase alpha abcaacCDD CFOUTPUT REFindNoCase alpha abcaacCDD CFOUTPUT P P REFindNoCase rep report cfm rep 1234 u 5 CFOUTPUT REFindNoCase rep report cfm rep...

Страница 520: ...pression you will find that the first element contains the position and length of the first instance of the whole expression The position and length of the first instance of each subexpression within...

Страница 521: ...emoveChars Example TITLE HEAD BODY BGCOLOR silver H3 RemoveChars Example H3 Returns a string with I count I characters removed from the specified starting position Returns 0 if no characters are found...

Страница 522: ...TLE RepeatString Example TITLE HEAD BODY BGCOLOR silver H3 RepeatString Example H3 P RepeatString returns a string created from I string I being repeated a specified number of times UL LI RepeatString...

Страница 523: ...st occurrence default ALL Replace all occurrences Examples This example shows the use of Replace HTML HEAD TITLE Replace Example TITLE HEAD BODY BGCOLOR silver H3 Replace Example H3 P The Replace func...

Страница 524: ...cement if one of your list1 elements is contained in list2 elements The second example listed below demonstrates such replacement Examples This example shows the use of Replacelist HTML HEAD TITLE Rep...

Страница 525: ...ME MyString P Substring 1 find this list of substrings BR INPUT TYPE Text VALUE Test String NAME MySubstring1 P Substring 2 replace with this list of substrings BR INPUT TYPE Text VALUE Replaced Sente...

Страница 526: ...urrence default ALL Replace all occurrences Examples This example shows the use of ReplaceNoCase HTML HEAD TITLE ReplaceNoCase Example TITLE HEAD BODY BGCOLOR silver H3 ReplaceNoCase Example H3 P The...

Страница 527: ...ion ONE Replace only the first occurrence default ALL Replace all occurrences Examples This example shows the use of REReplace HTML HEAD TITLE REReplace Example TITLE HEAD BODY BGCOLOR silver H3 RERep...

Страница 528: ...ence default ALL Replace all occurrences Examples This example shows the use of REReplaceNoCase HTML HEAD TITLE REReplaceNoCase Example TITLE HEAD BODY BGCOLOR silver H3 REReplaceNoCase Example H3 P T...

Страница 529: ...xample TITLE HEAD BODY BGCOLOR silver H3 Reverse Example H3 P Reverse returns your string with the positions of the characters reversed CFIF IsDefined FORM myString CFIF FORM myString is not P Reverse...

Страница 530: ...Defined Form MyText if len is 0 then err CFIF Len FORM myText is not 0 CFIF Len FORM myText LTE FORM RemoveChars P Your string CFOUTPUT FORM myText CFOUTPUT only has CFOUTPUT Len FORM myText CFOUTPUT...

Страница 531: ...use RJustify CFPARAM NAME jstring DEFAULT CFIF IsDefined FORM justifyString CFSET jstring Rjustify FORM justifyString 35 CFIF HTML HEAD TITLE RJustify Example TITLE HEAD BODY BGCOLOR silver H3 RJusti...

Страница 532: ...ple shows the use of Round HTML HEAD TITLE Round Example TITLE HEAD ODY H3 Round Example H3 P This function rounds a number to the closest integer UL LI Round 7 49 CFOUTPUT Round 7 49 CFOUTPUT LI Roun...

Страница 533: ...L HEAD TITLE RTrim Example TITLE HEAD BODY BGCOLOR silver H3 RTrim Example H3 CFIF IsDefined FORM myText CFOUTPUT PRE Your string FORM myText Your string Rtrim FORM myText right trimmed PRE CFOUTPUT C...

Страница 534: ...ng make sure it is enclosed in quotes Otherwise it is interpreted as a number representation of a date time object returning undesired results Examples This example shows the use of Hour Minute and Se...

Страница 535: ...delimited list of the locales that ColdFusion and the operating system support GetLocale will return an entry from that list SetLocale will fail if called with a locale name not on that list Example T...

Страница 536: ...session P A locale is an encapsulation of the set of attributes that govern the display and formatting of international date time number and currency values P The locale for this system is CFOUTPUT G...

Страница 537: ...This example uses SetProfileString to set the timeout value in an initialization file HTML HEAD TITLE SetProfileString Example TITLE HEAD body bgcolor FFFFD5 H3 SetProfileString Example H3 This exampl...

Страница 538: ...n file is already CFOUTPUT MyTimeout CFOUTPUT P CFIF CFSET timeout GetProfileString IniPath Section timeout CFSET DEFAULT GetProfileString IniPath Section default H4 Boot Loader H4 P Timeout is set to...

Страница 539: ...and the ClientManagement attribute of CFAPPLICATION tag has been set to Yes for this template Examples This example shows SetVariable HTML HEAD TITLE SetVariable Example TITLE HEAD BODY BGCOLOR silve...

Страница 540: ...ber number Any number Examples This example shows the use of Sgn HTML HEAD TITLE Sgn Example TITLE HEAD BODY H3 Sgn Example H3 P Sgn determines the sign of a number Returns 1 if number is positive 0 i...

Страница 541: ...BODY BGCOLOR silver H3 Sin Example H3 output its Sin value CFIF IsDefined FORM SinNum CFIF IsNumeric FORM SinNum Sin CFOUTPUT FORM SinNum CFOUTPUT CFOUTPUT Sin FORM sinNum Degrees Evaluate Sin FORM s...

Страница 542: ...anExcluding Example H3 CFIF IsDefined FORM myString P Your string was CFOUTPUT FORM myString CFOUTPUT P Your set of characters was CFOUTPUT FORM mySet CFOUTPUT P Your string up until one of the charac...

Страница 543: ...3 SpanIncluding Example H3 CFIF IsDefined FORM myString P Your string was CFOUTPUT FORM myString CFOUTPUT P Your set of characters was CFOUTPUT FORM mySet CFOUTPUT P Your string up until all of the ch...

Страница 544: ...he square root Usage Number must be greater than or equal to 0 Examples This example shows Sqr HTML HEAD TITLE Sqr Example TITLE HEAD BODY H3 Sqr Example H3 P Returns a positive square root for a numb...

Страница 545: ...tripCR Example H3 P Function StripCR is useful for preformatted HTML display of data PRE entered into TEXTAREA fields CFIF IsDefined FORM myTextArea PRE CFOUTPUT StripCR FORM myTextArea CFOUTPUT PRE C...

Страница 546: ...dd New Employees H1 Establish parms for first time through CFPARAM NAME FORM firstname DEFAULT CFPARAM NAME FORM lastname DEFAULT CFPARAM NAME FORM email DEFAULT CFPARAM NAME FORM phone DEFAULT CFPARA...

Страница 547: ...w StructClear and StructDelete CFSWITCH EXPRESSION ThisTag ExecutionMode CFCASE VALUE start CFIF StructIsEmpty attributes EMPINFO CFOUTPUT Error No employee data was passed CFOUTPUT CFEXIT METHOD Exit...

Страница 548: ...t this file copy the StructCount function to the appropriate place in addemployee cfm CFSWITCH EXPRESSION ThisTag ExecutionMode CFCASE VALUE start CFIF StructIsEmpty attributes EMPINFO CFOUTPUT Error...

Страница 549: ...f it does not Example This example shows how to use the StructDelete function HTML HEAD TITLE StructDelete Function TITLE HEAD basefont face Arial Helvetica size 2 body bgcolor FFFFD5 H3 StructDelete...

Страница 550: ...The code indicates rc P CFOUTPUT CFIF CFIF NOT IsDefined FORM Delete FORM ACTION structdelete cfm METHOD post P Select the field to be deleted nbsp select NAME field option VALUE firstname first name...

Страница 551: ...ear and StructDelete It is an example of a custom tag used to add employees Employee information is passed through the employee structure the EMPINFO attribute In UNIX you must also add the Emp_ID CFS...

Страница 552: ...ing an existing key The default is FALSE Usage This function throws an exception if structure does not exist or if key exists and allowoverwrite is set to FALSE Example This example shows how to use t...

Страница 553: ...yee phone P P Department is StructFind employee department P CFOUTPUT Call the custom tag that adds employees CF_ADDEMPLOYEE EMPINFO employee CFIF Hr FORM ACTION structinsert cfm METHOD post P First N...

Страница 554: ...custom tag used to add employees Employee information is passed through the employee structure the EMPINFO attribute In UNIX you must also add the Emp_ID CFSWITCH EXPRESSION ThisTag ExecutionMode CFC...

Страница 555: ...array It also uses the StructNew function to create the structure and fills its fields with the information the user types into the corresponding form fields HTML HEAD TITLE StructKeyArray Function TI...

Страница 556: ...st Name td td INPUT NAME firstname TYPE text VALUE hspace 30 maxlength 30 td tr tr td Last Name td td INPUT NAME lastname TYPE text VALUE hspace 30 maxlength 30 td tr tr td EMail td td INPUT NAME emai...

Страница 557: ...Chapter 2 ColdFusion Functions 533 P CFOUTPUT Value i is employee keysToStruct i CFOUTPUT P CFLOOP CFIF BODY HTML...

Страница 558: ...r to addemployee cfm which is called by StructNew StructClear and StructDelete To test this file copy the LT CFELSEif GT statement to the appropriate place in addemployee cfm It is an example of a cus...

Страница 559: ...ist Example This example shows how to use the StructKeyList function to list the keys within a specified structure It also uses the StructNew function to create the structure and fills its fields with...

Страница 560: ...nformation into a database See CFQUERY for more information about database insertion hr size 2 color 0000A0 FORM ACTION structkeylist cfm METHOD post table cellspacing 2 cellpadding 2 border 0 tr td F...

Страница 561: ...0A0 CFSET keysToStruct StructKeyList employee LI P Here are the keys to the structure P UL LI CFOUTPUT keysToStruct CFOUTPUT UL P If these fields are correct we can process your new employee informati...

Страница 562: ...RM lastname DEFAULT CFPARAM NAME FORM email DEFAULT CFPARAM NAME FORM phone DEFAULT CFPARAM NAME FORM department DEFAULT CFIF FORM firstname EQ P Please fill out the form CFELSE CFOUTPUT CFSCRIPT empl...

Страница 563: ...s usage of StructUpdate P This file is similar to addemployee cfm which is called by StructNew StructClear and StructDelete To test this file copy the LT CFELSEIF GT statement to the appropriate place...

Страница 564: ...in radians for which you want the tangent If the angle is in degrees multiply it by PI 180 to convert it to radians Examples This example shows Tan HTML HEAD TITLE Tan Example TITLE HEAD BODY H3 Tan...

Страница 565: ...eading zero for single digit hours Uses a 24 hour clock m Minutes with no leading zero for single digit minutes mm Minutes with a leading zero for single digit minutes s Seconds with no leading zero f...

Страница 566: ...display that date time value in a number of different ways CFOUTPUT UL LI TimeFormat todayDate LI TimeFormat todayDate hh mm ss LI TimeFormat todayDate hh mm sst LI TimeFormat todayDate hh mm sstt LI...

Страница 567: ...it encoding of 8 bit ASCII characters Because high ASCII values and binary objects are not safe for transport over internet protocols such as HTTP and SMTP ColdFusion offers Base 64 as a means to safe...

Страница 568: ...oBase64 charData Convert string to binary CFSET binaryData toBinary data64 Convert binary back to Base 64 CFSET another64 toBase64 binaryData Compare another64 with data64 to ensure that they are equa...

Страница 569: ...e that it is an acceptable binary value Usage Base 64 provides 6 bit encoding of 8 bit ASCII characters If you receive data in Base 64 you can re create the actual binary object that it represents suc...

Страница 570: ...FSET binaryData toBinary data64 Convert binary back to Base 64 CFSET another64 toBase64 binaryData Compare another64 with data64 to ensure that they are equal CFIF another64 eq data64 H3 Base 64 repre...

Страница 571: ...the use of ToBase64 ToBinary and ToString HTML HEAD TITLE ToString Example TITLE HEAD BODY BGCOLOR silver H3 ToString Example H3 Initialize data CFSET charData Create a string of all ASCII characters...

Страница 572: ...ation of Base 64 data CFSET dataBinary toBinary data64 Create the string repesentation of the binary data CFSET dataString toString dataBinary P The following is the string representation of the binar...

Страница 573: ...HEAD TITLE Trim Example TITLE HEAD BODY BGCOLOR silver H3 Trim Example H3 CFIF IsDefined FORM myText CFOUTPUT PRE Your string FORM myText Your string trim FORM myText trimmed on both sides PRE CFOUTPU...

Страница 574: ...lver H3 UCase Example H3 CFIF IsDefined FORM sampleText CFIF FORM sampleText is not P Your text CFOUTPUT FORM sampleText CFOUTPUT returned in uppercase is CFOUTPUT UCase FORM sampleText CFOUTPUT CFELS...

Страница 575: ...in HTTP are always URL encoded URL encoded strings can be created using the URLEncodedFormat function Example Here is an example of the URLDecode and URLEncodedFormat functions In the example a strin...

Страница 576: ...the character code For example a character with code 129 will be encoded as 81 In addition spaces can be encoded using the plus sign Query strings in HTTP are always URL encoded URL encoded strings c...

Страница 577: ...theTestValue CFIF Val FORM theTestValue is not 0 H3 The string CFOUTPUT DE FORM theTestValue CFOUTPUT can be converted to a number CFOUTPUT Val FORM theTestValue CFOUTPUT H3 CFELSE H3 The beginning o...

Страница 578: ...to separate column data Example This example shows the use of ValueList HTML HEAD TITLE ValueList Example TITLE HEAD BODY H3 ValueList Example H3 use the contents of one query to create another dynami...

Страница 579: ...d results Examples shows the value of the Week function HTML HEAD TITLE Week Example TITLE HEAD BODY BGCOLOR silver H3 Week Example H3 CFIF IsDefined FORM year More information about your date CFSET y...

Страница 580: ...not use WriteOutput within CFQUERY and CFMAIL This function writes to the page output stream regardless of conditions established by the CFSETTING tag Syntax WriteOutput string string Text to be appen...

Страница 581: ...reater than sign less than sign single quotation mark double quotation mark ampersand Examples This example illustrates use of the XMLFormat function HTML HEAD TITLE XMLFormat TITLE HEAD BODY H3 XMLFo...

Страница 582: ...s shows the value of the Year function HTML HEAD TITLE Year Example TITLE HEAD BODY BGCOLOR silver H3 Year Example H3 CFIF IsDefined FORM year More information about your date CFSET yourDate CreateDat...

Страница 583: ...YES and zero values as NO Examples This example shows the YesNoFormat HTML HEAD TITLE YesNoFormat Example TITLE HEAD BODY H3 YesNoFormat Example H3 P The YesNoFormat function returns all non zero valu...

Страница 584: ...560 CFMLLanguageReference...

Страница 585: ...pter 3 WDDX JavaScript Objects This chapter provides information about JavaScript objects and functions used when implementing WDDX in a ColdFusion application Contents WddxSerializer Object 562 WddxR...

Страница 586: ...ds and a null value if an error occurs Usage Call this function to serialize the data in a WddxRecordset instance Example This example illustrates a JavaScript function that you can call to serialize...

Страница 587: ...function Example This example is from the WddxSerializer serializeValue function Some generic object treat it as a structure this write struct for prop in obj bSuccess this serializeVariable prop obj...

Страница 588: ...nction this wddxPacket this write wddxPacket version 1 0 header data bSuccess this serializeValue rootObj this write data wddxPacket if bSuccess return this wddxPacket else return null write Appends d...

Страница 589: ...ified column to all rows in the WddxRecordset instance Syntax object addColumn name object Instance name of the WddxRecordset object name Name of the column to add Return value None Usage This functio...

Страница 590: ...ry column of the WDDX record set Initially the row column values are set to NULL Example This example calls the addRows function create a new recordset rs new WddxRecordset add a new column rs addColu...

Страница 591: ...w 0 row nRows row o tr for i 0 i colNames length i o td r getField row colNames i td o tr getRowCount Indicates the number of rows in the WddxRecordset instance Syntax object getRowCount object Instan...

Страница 592: ...Value to be set Return value None Usage Call this function to set a value in a WddxRecordset instance Example This example calls the setField function create a new recordset rs new WddxRecordset add a...

Страница 593: ...rror occurs Usage Internal You do not typically call this function Example This example is from the WddxSerializer serializeValue function else if typeof obj object if obj null Null values become empt...

Страница 594: ...570 CFMLLanguageReference...

Страница 595: ...nd Other Constructs This chapter describes ColdFusion expressions language constructs that allow you to create sophisticated applications Contents Elements of ColdFusion Expressions 572 Operators 576...

Страница 596: ...available memory on the ColdFusion server To use a single quote inside a string that is single quoted escape the single quote by using two single quotes You can similarly escape a double quote inside...

Страница 597: ...cters to the delimiters Delimiters before the first element and after the last element are ignored The structure of lists is flat that is lists cannot be nested into one another Also lists can contain...

Страница 598: ...ve the same name at the same time in the same application page COM objects COM Component Object Model objects are non visual components that encapsulate specific functionality you can invoke in your a...

Страница 599: ...fer to dates in expressions in the following order month day and year For example CFIF 11 23 1998 GT 11 15 1998 If this switch is set the default date format returned by the DateFormat function cannot...

Страница 600: ...s Operators combine sub expressions to create more complex expressions The general syntax for using operators is Expression Operator Expression ColdFusion has four types of operators Arithmetic operat...

Страница 601: ...mber from the power The left operand cannot be zero For example 2 3 is 8 Arithmetic Operators Continued Operator Description String Operators Operator Description Concatenates strings Decision Operato...

Страница 602: ...to the value on the right and returns true if it is LESS THAN OR EQUAL TO Checks to see if the value on the left is less than or equal to the value on the right and returns true if it is Shorthand Not...

Страница 603: ...ALSE and vice versa AND Returns TRUE if both arguments are TRUE returns FALSE otherwise For example TRUE AND TRUE is TRUE but TRUE AND FALSE is FALSE OR Returns TRUE if any of the arguments is TRUE re...

Страница 604: ...e default value For example Replace FooFoo Foo Boo returns BooFoo Replace FooFoo Foo Boo ALL returns BooBoo The difference in behavior is explained by the fact that the Replace function takes an optio...

Страница 605: ...bove the expression Form MyFormVariable is replaced with whatever value has been assigned to it While the guidelines for using pound signs in CFML are simple there is still some possibility for confus...

Страница 606: ...he value returned by the function For example the following pairs of CFSET statements produce the same result CFSET TheString Hello FirstName CFSET TheString Hello FirstName If pound signs are not use...

Страница 607: ...ME TestCookie VALUE CookieValueArray Index This usage is more efficient than VALUE CookieValue Nested pound signs There are very few cases in which pound signs can be nested inside the same expression...

Страница 608: ...expressions Allaire recommends that pound signs be used only where necessary The following example demonstrates the preferred method for referencing variables CFSET SomeVar Var1 Max Var2 10 Var3 Var4...

Отзывы:

Нет отзывов

Бренды по названию

Популярные бренды

Загрузить еще бренды