Macromedia Coldfusion MX 7 Web Application Construction Kit

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

sample applications

    creating birthday application (Dreamweaver) [See Orange Whip Studios]

    OWS data files [See Orange Whip Studios]

        Actors table [See Orange Whip Studios]

        Contacts table [See Orange Whip Studios]

        Directors table [See Orange Whip Studios]

        Expenses table [See Orange Whip Studios]

        Films table [See Orange Whip Studios]

        FilmsActors table [See Orange Whip Studios]

        FilmsDirectors table [See Orange Whip Studios]

        FilmsRatings table [See Orange Whip Studios]

        Merchandise table [See Orange Whip Studios]

        MerchandiseOrders table [See Orange Whip Studios]

        MerchandiseOrdersItems table [See Orange Whip Studios]

        UserRoles table [See Orange Whip Studios]

samples, installing from CD 2nd

Sams Teach Yourself Regular Expressions in 10 Minutes (Sams)

Sandbox Security

     basics of

     Sandbox Security page (CF Admin), CD29 2nd 3rd 4th 5th

save class files option, CD29

saving

     CFCs

     files in Dreamweaver

     UDFs 2nd 3rd 4th

scalability of databases

scheduled tasks

    scheduler.log file, CD36 [See code listings;event scheduling]

scheduling events [See code listings;event scheduling]

scoped locks, vs. named locks 2nd 3rd

scopes

     shared scopes

score operators 2nd

screen resolution

scripting, and user experience

Scripts pop-up menu

search engines

    Verity [See Verity search engine]

searching

    <cfsearch> results variables [See Verity search engine]

    Flash remoting, example search interface [See Verity search engine]

    search forms (CF)

        dynamic search screens, creating [See Verity search engine]

        HTML form tags, creating search forms with [See Verity search engine]

    search modifiers [See Verity search engine]

    search path, changing [See Verity search engine]

    Verity searches

        for > (greater than) sign [See Verity search engine, ]

        for special characters [See Verity search engine, ]

        Verity search tags, listed by function [See Verity search engine, ]

    WHERE clauses, SQL [See Verity search engine]

searching, full-text, CD35 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th

    collections, Verity

         <cfcollection>, CD35 2nd 3rd 4th

         basics of, CD35 2nd 3rd 4th 5th 6th

         creating new, CD35 2nd

         creating programmatically, CD35 2nd

         deleting, CD35

         indexing, CD35 2nd 3rd 4th 5th

         optimizing, CD35 2nd

         repairing, CD35 2nd

         repopulating, CD35 2nd

         searching multiple collections, CD35 2nd

     indexing SQL data, CD35 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th [See also table data (SQL]

         key table values, Verity and, CD35 [See also table data (SQL]

         searching without Verity, CD35 2nd 3rd [See also table data (SQL]

         Verity search, combining with SQL queries, CD35 2nd 3rd [See also table data (SQL]

     search interface, creating, CD35 2nd 3rd 4th 5th 6th 7th 8th

         parentheses and quotation marks, using, CD35

         search form page, CD35 2nd

         search results page, CD35 2nd 3rd 4th 5th

     Verity operators and search syntax, CD35 2nd

secure downloads, CD33

Secure Sockets Layer (SSL)

     encryption basics 2nd

     server certificate

security

     application-based 2nd

     cookies, marking as secure

     Flash, logging in from and 2nd

     importance of

     of operating systems 2nd 3rd

     parameterized queries for, CD30 2nd

     Sandbox Security, , CD29

     security functions, listed 2nd

     security section (CF Admin), CD29 2nd 3rd 4th 5th

         CF Admin Password page, CD29

         RDS Password page, CD29

         Sandbox Security page, CD29 2nd 3rd 4th 5th

     security tags, listed

     stored procedures and, CD31

security of applications 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th

     access, controlling 2nd

     application-based 2nd

     authentication with session variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st

         <cflogin> 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

         access levels 2nd 3rd

         access rights, users and groups 2nd

         application access, restricting 2nd

         getAuthUser( ) in application pages 2nd 3rd 4th

         login name and password, verifying 2nd 3rd

         login pages, creating 2nd 3rd 4th

         login status, checking and maintaining 2nd

         login, delaying

         login, personalizing 2nd 3rd

         passed parameters 2nd 3rd 4th 5th 6th

         roles, to restrict functionality 2nd 3rd 4th 5th

     cross-site scripting, defending against

     options 2nd 3rd 4th 5th

         <cflogin> framework

         application-based security 2nd

         HTTP basic authentication 2nd

         OS security 2nd 3rd

         Sandbox Security, , CD29

         SSL encryption 2nd

Select control (Flash forms)

SELECT statements, SQL

     defined

     dynamic SQL statements, building

     overuse of subqueries in, CD37

     SQL Query tool and

SENTENCE operators

Serial Number Change (CF Admin), CD29

serialization, defined, CD32

seriesplacement attribute, <cfchart>

server behaviors panel (Dreamweaver) 2nd

server configuration with ColdFusion Administrator, CD29 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd

     ColdFusion Administrator overview, CD29

     Data and Services section, CD29 2nd 3rd 4th 5th

         Data Sources page, CD29 2nd

         Verity Collections page, CD29 2nd

         Verity K2 Server page, CD29 2nd

         Web Services page, CD29 2nd

     Debugging and Logging section, CD29 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

         CFX Tags page, CD29 2nd 3rd

         Code Analyzer page, CD29 2nd

         CORBA Connectors page, CD29 2nd

         Custom Tag Paths page, CD29

         Debugging IP Addresses page, CD29

         Debugging Settings page, CD29 2nd 3rd 4th 5th

         Java Applets page, CD29

         Log Files page, CD29

         Logging Settings page, CD29 2nd 3rd

         System Probes page, CD29 2nd 3rd

     Event Gateways section, CD29 2nd 3rd

         Gateway Instances page, CD29

         Gateway Types page, CD29

         Settings page, CD29 2nd

     home page, CD29

     packaging and deployment, CD29 2nd 3rd 4th 5th 6th

         ColdFusion archives (.car), CD29 2nd 3rd 4th 5th

         J2EE Archives page, CD29 2nd

     security section, CD29 2nd 3rd 4th 5th

         ColdFusion Administrator Password page, CD29

         RDS Password page, CD29

         Sandbox Security page, CD29 2nd 3rd 4th 5th

     server settings, CD29 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

         Caching page, CD29 2nd 3rd

         Charting page, CD29 2nd

         Client Variables page, CD29 2nd 3rd

         Font Management page, CD29 2nd

         Java and JVM page, CD29 2nd 3rd

         Memory Variables page, CD29 2nd

         Settings page, CD29 2nd 3rd 4th 5th 6th 7th

         summary of, CD29

Server Debug button

server folders, manipulating with <cfdirectory>, CD34 2nd 3rd 4th 5th 6th 7th 8th

     attributes and actions, CD34 2nd

    directories

         creating, renaming deleting and listing, CD34 2nd

         obtaining contents of, CD34

     file explorer, building, CD34 2nd 3rd 4th 5th

server-side files, creating, CD33

server-side formatting (Dreamweaver)

server-side validation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

     <cfparam> and 2nd 3rd 4th

     automatic 2nd 3rd 4th 5th 6th

     manual 2nd 3rd 4th 5th

     supported validation types 2nd

     vs. client-side validation 2nd

servers

     client variables, sharing between 2nd

    ColdFusion Application Server

         basics of 2nd 3rd

         verifying running of 2nd

     database servers, , CD30

     defined

    mail servers

         defining (CF Admin) 2nd

         overriding default settings 2nd

         specifying in CF Admin 2nd

     production servers, defined

     remote servers

     secure servers for online commerce

     server software, defined

     SERVER variables

     SQL Server Enterprise Manager tool, CD31

     Web application servers 2nd

    Web servers

         basics of 2nd 3rd 4th 5th 6th

         checking for CF installation

         configuration problems, debugging 2nd

service functions

     CF pages as 2nd

     CFCs as 2nd

SESSION scope

     maintaining structure in 2nd

     storing CFCs in

session variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd [See also authentication using session variables]

     defined 2nd 3rd [See also authentication using session variables]

     deleting 2nd 3rd [See also authentication using session variables]

     enabling [See also authentication using session variables]

     examples of [See also authentication using session variables]

     multiple-page, and data entry 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th [See also authentication using session variables]

         deleting 2nd 3rd [See also authentication using session variables]

         structures in SESSION scope [See also authentication using session variables]

     pre-defined 2nd [See also authentication using session variables]

     pros and cons of [See also authentication using session variables]

     without cookies [See also authentication using session variables]

SESSION-scoped structures and arrays

sessions, working with 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th

    client variables [See client variables]

    cookies and [See cookies]

     ending sessions 2nd 3rd

     locking 2nd

     onSessionStart and on SessionEnd methods

    session variables [See session variables]

     statelessness of Web 2nd 3rd

     variables, types of

SET keyword

set-manipulation functions, listed 2nd

setClientCookies attribute

settings

    default mail server settings, overriding [See server configuration with ColdFusion, server configuration with ColdFusion Administrator, CD29;server settings]

    remembering [See server configuration with ColdFusion, server configuration with ColdFusion Administrator, CD29;server settings]

    Setting Summary screen (CF Admin) [See server configuration with ColdFusion, server configuration with ColdFusion Administrator, CD29;server settings]

    Settings page (CF Admin), CD29 [See server configuration with ColdFusion, server configuration with ColdFusion Administrator, CD29;server settings]

Setup Wizard, Report Builder 2nd

setVariable( ) function 2nd

shared scopes, access to

shared-file-based databases 2nd

shopping carts 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th

     appearance of

     building 2nd 3rd 4th 5th

     CFC version of 2nd 3rd 4th 5th 6th 7th 8th 9th

     encapsulating cart custom tags 2nd 3rd 4th 5th 6th

     storing cart information 2nd 3rd

short-circuit evaluation

Show All option, adding 2nd 3rd 4th 5th 6th

Simple Mail Transport Protocol (SMTP)

     defined

     mail servers (CF Admin) 2nd 3rd

SimpleJavaScriptFunctions library 2nd 3rd

simultaneous requests, setting maximum, CD29 2nd 3rd 4th

single quotation marks (') 2nd

Site-Spring (Macromedia)

sites

    defined, CD37 [See Web sites]

    Site Definition dialog box, CD37 [See Web sites]

    site definitions (Dreamweaver) [See Web sites]

        advanced site definition dialog [See Web sites]

        site creation [See Web sites]

    Site Map layout (Dreamweaver) [See Web sites]

skins

     colored 2nd

     Flash forms 2nd

     XSL 2nd 3rd 4th

SMS test server, CD29

SMTP [See Simple Mail Transport Protocol (SMTP]

Snippets panel (Dreamweaver) 2nd 3rd 4th

SOAP functions, listed

software

     client software, defined

     Norton Internet Security software

     Payflow Pro software 2nd 3rd 4th 5th 6th 7th 8th

     server software, defined

Solaris systems, installing ColdFusion MX on

SOUNDEX operator

source code tracking

spaces, as delimiters

special characters, searching for, Verity

special ColdFusion variables and result codes

     <cfcatch> variables

     <cfcollection action="list"> query columns 2nd

     <cfdirectory action="list"> query columns

     <cffile action="upload"> variables 2nd

     <cfftp action="ListDir"> query columns

     <cfftp> variables 2nd

     <cfhttp> variables 2nd

     <cfldap action="query"> query columns

     <cfpop action="GetHeaderOnly | GetAll"> query columns 2nd

     <cfquery> variables

     <cfregistry> query variables

     <cfsearch> results variables 2nd

     <cfservlet> variables

     <cfstoredproc> variables

     ATTRIBUTE variables

     CALLER variables

     CGI variables 2nd 3rd 4th

     COOKIE variables

     ERROR variables 2nd

     FORM variables

     listed 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

     query variables 2nd

     REQUEST variables

     SERVER variables

     SESSION variables 2nd

     THISTAG variables

     URL variables

special ColdFusion variables and result codes, listed 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

spreadsheets, Excel

     creating with tab-separated text, CD33 2nd 3rd

     with HTML, CD33 2nd 3rd 4th 5th

SQL [See Structured Query Language (SQL]

SSL (Secure Sockets Layer)

     encryption basics 2nd

     server certificate

Stage (Flash), defined

staging environments, defined

start-up (Dreamweaver) 2nd 3rd

STARTS operator

statements

     else statements (CFML) 2nd 3rd

     if statements (CFML) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

         basic 2nd 3rd

         Guess the Number example 2nd 3rd 4th 5th 6th 7th 8th

         if and else 2nd 3rd

         multi-condition 2nd 3rd

         multiple 2nd 3rd

     SQL statement errors, debugging 2nd 3rd

     SQL statements supported by QofQ, CD30

    SQL-based data manipulation statements

         basics of

         DELETE statement 2nd 3rd

         INSERT SELECT statement

         INSERT statement 2nd 3rd 4th

         UPDATE statement 2nd 3rd

     switch statements (CFML) 2nd 3rd

static charts

static components

     CFCs and

     defined

static Web pages

     data-driven Web pages and 2nd

     described

status codes

     defining, CD31 2nd

step attribute

storage mechanism setting, CD29 2nd 3rd

stored procedures, CD31 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd

     <cfquery>, calling procedures with, CD31 2nd 3rd 4th

     advantages of, CD31 2nd 3rd

     creating, CD31 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

         with Microsoft SQL Server, CD31 2nd 3rd 4th

         with Oracle, CD31 2nd 3rd 4th 5th

     executing, CD31 2nd 3rd

     ImportCustomers stored procedure, CD31

     purpose of, CD31 2nd

    recordsets, returning with

         <cfprocresult>, CD31 2nd 3rd 4th 5th

         using, CD31 2nd 3rd 4th 5th 6th

     Stored Procedure objects

     taking parameters and returning status codes with, CD31 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

         <cfprocparam>, providing parameters with, CD31 2nd 3rd 4th

         custom tags, wrapping calls in, CD31

         multiple recordsets supported with, CD31 2nd 3rd 4th

         ordinal vs. named parameter positioning, CD31 2nd

         parameter data types, CD31

     transactions and, CD30

     vs. CFML custom tags, CD31

storefronts, creating 2nd 3rd 4th 5th 6th 7th

     individual items, displaying 2nd 3rd

     items, collecting into store 2nd 3rd 4th

storyboards and flowcharts in application planning

string-manipulation functions, listed 2nd

struct notation

structDelete( ) function 2nd

StructNew( ) function

structured development and CFCs 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th

     basics of structured development 2nd 3rd 4th

     creating first CFC 2nd 3rd 4th 5th 6th

         <cfargument> 2nd 3rd

         <cfcomponent>

         <cffunction> 2nd

         <cfreturn> 2nd

     documenting CFCs 2nd

     Dreamweaver CFC support 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

         CFC method invocation 2nd 3rd 4th 5th 6th

         recordsets, using CFCs as 2nd 3rd 4th

         wizard-based CFC creation 2nd 3rd 4th 5th 6th 7th 8th 9th

     invoking CFCs 2nd

     saving CFCs

     templates (CF) vs. CFCs

     unit testing

Structured Query Language (SQL) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th [See also dynamic SQL]

     data manipulation statements 2nd 3rd 4th 5th 6th 7th 8th [See also dynamic SQL]

         DELETE statement 2nd [See also dynamic SQL]

         global database updates 2nd [See also dynamic SQL]

         INSERT statement 2nd 3rd 4th [See also dynamic SQL]

         listed and defined [See also dynamic SQL]

         modifying data with UPDATE statement 2nd 3rd [See also dynamic SQL]

     data sources, creating 2nd 3rd 4th 5th 6th 7th [See also dynamic SQL]

         from within Dreamweaver 2nd 3rd [See also dynamic SQL]

         using CF Admin 2nd 3rd [See also dynamic SQL]

     filtering data 2nd 3rd 4th 5th 6th 7th 8th [See also dynamic SQL]

         AND and OR operators 2nd [See also dynamic SQL]

         on multiple columns 2nd [See also dynamic SQL]

         on single columns [See also dynamic SQL]

         WHERE clause search conditions 2nd 3rd 4th 5th [See also dynamic SQL]

     history of [See also dynamic SQL]

     indexing SQL data, CD35 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th [See also dynamic SQL, table data (SQL]

         key table values, Verity and, CD35 [See also dynamic SQL, table data (SQL]

         searching without Verity, CD35 2nd 3rd [See also dynamic SQL, table data (SQL]

         Verity search, combining with SQL queries, CD35 2nd 3rd [See also dynamic SQL, table data (SQL]

     ORDER BY clauses, creating [See also dynamic SQL]

     SQL INSERT, vs. <cfinsert> [See also dynamic SQL]

     SQL queries 2nd 3rd 4th 5th 6th [See also dynamic SQL]

         creating 2nd 3rd 4th [See also dynamic SQL]

         sorting query results 2nd [See also dynamic SQL]

     SQL Query Builder 2nd 3rd [See also dynamic SQL]

     SQL Query tool (sql.cfm) 2nd 3rd [See also dynamic SQL]

     SQL Server Enterprise Manager tool, CD31 [See also dynamic SQL]

     statement errors, debugging 2nd 3rd [See also dynamic SQL]

Structured Query Language (SQL), advanced topics, CD30 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th

     aggregate functions for summarizing data, CD30 2nd 3rd 4th 5th 6th 7th 8th

         GROUP BY clauses and, CD30 2nd

         HAVING keyword, filtering records with, CD30 2nd 3rd 4th

         standard aggregate functions, CD30 2nd 3rd

         WHERE clauses and, CD30

     date values, CD30 2nd 3rd

     DISTINCT keyword, unique records with, CD30 2nd 3rd

     joins, selecting data with, CD30 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

         join syntax, CD30 2nd 3rd 4th 5th

         joining three tables, CD30 2nd

         joining two tables, CD30 2nd 3rd

         table aliases, improving readability with, CD30 2nd 3rd

     NULL values, CD30 2nd 3rd

     subqueries, CD30 2nd 3rd 4th 5th 6th 7th

         alternatives to, CD30 2nd

         calculating new columns with, CD30

         in WHERE criteria, CD30 2nd

         using with IN keyword, CD30 2nd

         using with NOT IN operator, CD30 2nd 3rd

     UNION operator, combining record sets with, CD30 2nd 3rd 4th

     views, CD30 2nd

structures

     basics of 2nd 3rd

     data types 2nd 3rd

     returning to Flash

     SESSION-scoped

     structure-manipulation functions, listed 2nd

Style Definitions dialog box 2nd

style values

styles, defining 2nd

subqueries (SQL), CD30 2nd 3rd 4th 5th 6th 7th

     alternatives to, CD30 2nd

     calculating new columns with, CD30

     in WHERE criteria, CD30 2nd

     overuse of, CD37

     using with IN keyword, CD30 2nd

     using with NOT IN operator, CD30 2nd 3rd

Subreport button

SUBSTRING operator

SUM operator

suppressWhitespace="No" attribute

SWF files, defined

switch statements (CFML) 2nd 3rd

syntax errors, debugging 2nd

system functions, listed

System Information screen (CF Admin), CD29

System Probes page (CF Admin), CD29 2nd 3rd

system Registry, CD29:13-14, CD34 2nd 3rd 4th 5th