Where to Go From Here

This guide provides you with the information you need todevelop Web applications and administer the ColdFusion Express Server.

From here, you can do any of the following to learn more about and do more with ColdFusion:

Check out the ColdFusion Express sample application at

http://localhost/ cfdocs/exampleapp/globalcorp/index.cfm/.
Attend a ColdFusion training class in your area.
See

/training.cfmwww.allaire.com/developer/training.cfmUpgrade to ColdFusion Enterprise Server or ColdFusion Professional Server, and ColdFusion Studio.

More detailed information on upgrade opportunities can be found online at www.allaire.com/coldfusion

158 Developing Web Applications with ColdFusion Express

A

Access

ODBC options 144 Adding

data sources 142 Administering ColdFusion

initial tasks 127

overview 126 summary of tasks 127

Administrator

accessing remotely 126

URL 126

Administrator, Cold Fusion 12 Administrator, ColdFusion

about basic security 152 about security 135

accessing 126

debugging options 138

logging 136

mapping directories 136 ODBC data sources 141 opening 132

remote access 132 Server Settings page 134

Allaire 4

contacting 4

headquarters 4

sales 5

technical support 4 AND usage example 100 Apache servers 16 Apache Web Server 18 Application page

cookies 41

Application page connectivity 9 Application page contents 8 Application pages and HTML pages 8 application.log file 137

Arithmetic 86

arrays 33

AUTH_TYPE variable 39 Automatic table generation,

about 155

B

Basic security 152

about 152

batch files 133

Boolean 86

boolean 84 Browser

cookies 40

C

CFCASE 83

CFELSE 83

CFELSEIF 91

cfexec.log file 137

CFIF 83

CFINCLUDE tag 136

CFLOCATION 91, 93

CFLOOP 82 CFQUERY tag

properties 53

CFSET tag 32

CFSWITCH 83

CGI (Common Gateway Interface) environment variables 38

check box 73

Checkbox 76, 84 Client variables

creating a data source for 154 creating data source tables 155 disabling global updates 155 enabling data source for 154 migrating 155

planning state management 152 purging 154

storage options 154 ways of managing 152

Client variables storage browser cookies 152

external repository 152

system registry 152 ColdFusion

developer resources 4

documentation, about 2 log file directories 136 processes on Solaris 128 starting 128

supported databases 142

ColdFusion Administrator 12, 47, 54 ColdFusion applications, keep these

guidelines 42

ColdFusion Components 8 ColdFusion counters

types of 140 ColdFusion performance

monitoring 139

ColdFusion processing order 91 ColdFusion services, Windows NT 128 ColumnList property. See CFQUERY tag

record numbers 54

COM 10, 46

Comparison 86

Conditional Logic with SQL usage example 101

conditional processing and cookies 41

conditional processing based on a CGI variable 39

CONTENT_LENGTH variable 39

CONTENT_TYPE variable 39 Cookie, HTTP

creating 40

CORBA 10

Currency 66

CurrentRow property. See CFQUERY record numbers 54

customtag.log file 137

D

data source 46 Data sources

about 142

verifying 148

database 46

Databases supported 142

Dates 66 dBase

ODBC options 145

DCOM 46

Debugging Administrator 138

debug output options 138 output to an IP number 138

decision functions 84 Directory

mapping 136

Disabling global client variable updates 155

Documentation conventions 2

Driver, ODBC 144

Dynamic parameters. See also Variables 29

E

Enforce strict attribute validation 134 Error logging 136

errors.log file 137

Excel 145, 154

F

fine-tuning and configuring 13 FORM tag 72

Functions types 65

G

GATEWAY_INTERFACE variable 38

H

HTML 66

HTTP cookie creating 40

HTTP_REFERER variable 39

HTTP_USER_AGENT variable 39

I

IDE service icon 129

IP number, specifying for debug output 138

IsDate 84

IsDefined 84

L

LDAP 46

LDAP servers 62

leverage 9

Limit Connections option 147 Limit database connection inactive

time 134

Limit maximum number of cached queries 134

Limit simultaneous requests 134 Log files 137

application.log 137

cfexec.log 137

created by ColdFusion 137 customtag.log 137

directories for 136

error logging 136

errors.log 137

rdeservice.log 137

remote.log 137

schedule.log 137

server.log 137

specifying new location for 136 tracking slow pages with 136 webserver.log 137

Log files, ColdFusion Administrator 136

Logging, ColdFusion Administrator 136

M

mail server 46

mail servers 62

Maintain database connections option 147

Mapping 136

Administrator 136

Microsoft Access 144

ODBC options 144

Microsoft Internet Information servers (IIS) 16

multiple tables 100

N

Names

variables 38 nest CFIF tags 91

Netscape servers 16

Numbers

Numbers 66

O

O’Reilly WebSite servers 16 ODBC 46, 47

ODBC data sources Access options 144

Administrator 141

configuring (Windows) 142

dBase options 145

drivers for 144

Microsoft Excel 145

options 147

options (Windows) 143

text options 146

ODBC name 47

ODBC options 145 ODBC settings

advanced for ColdFusion 147 ColdFusion Login option 147

Opening, ColdFusion Administrator 132

Output, restricting 138

P

page navigation 58

Page proccessing order 22 Page processing order 12 Paragraphs 66

PATH_INFO variable 38

PATH_TRANSLATED variable 38

pattern matching 99 Performance monitor configuring 140

enabling for ColdFusion (Windows NT) 140

programatic looping 82 Purging

client variables 154

Q

Query, data

record number 53

QUERY_STRING variable 39

R

radio button 76, 84

radio buttons 73

rdseservice.log file 137 RecordCount property. See CFQUERY

record numbers 54 Recordcount usage example 103 redirect users to another URL 92 Registry, increasing maximum

size 153

Registry, maximum size 153 Registry, using to store client

variables 152

remote.log file 137

REMOTE_ADDR variable 39

REMOTE_HOST variable 39

REMOTE_IDENT variable 39

REMOTE_USER variable 39

REQUEST_METHOD variable 38

reset button 73

Restart unresponsive server 134 Restrict SQL operations option 147 run-time information 54

S

schedule.log file 137 Scope

variables 38

SCRIPT_NAME variable 38 Search interface output usage

example 103 Security

About Basic 152

select box 73, 76 Server

Limit connections option 147 Limit database connection

time 134

Limit maximum number of cached queries 134

Limit simultaneous requests 134 Server processing 25

Server variables CGI 38

server.log file 137

SERVER_NAME variable 38

SERVER_PORT variable 38

SERVER_PROTOCOL variable 38

SERVER_SOFTWARE variable 38

Simultaneous requests limiting 134

Slow pages tracking 136

SQL AND clause 99 SQL LIKE operator 99 SQL WHERE 99

SQL wildcard strings 99

SSL (Secure Sockets Layer) 41 Starting ColdFusion 128, 129 State management, external

client 153 Stopping ColdFusion

reasons for 129

String 86

structures 33

submit button 73

System Needs 16 System registry

increasing maximum size 153 maximum size 153

system tray 129

T

Table joins usage example 100 Tables joins 100

Technical support, contacting 4 Template cache size 134

Text

ODBC options 146

text contol 73

Text data sources 154 Timeout requests 134

Times 66

true or false 86 Trusted cache 134

U

Usage 100

Usage example 103

V

variable naming conventions 42 variable scope and prefix table 43 Variables

CGI environment 38

CGI server 38

Verifying data sources 148

W

Web Server compatibility 16 Web site

Allaire 4

webserver.log file 137

When clients request a ColdFusion application page

Windows 95

starting ColdFusion 129 Windows NT

starting ColdFusion 128

162 Developing Web Applications with ColdFusion Express