User Guide

Index 417
CFScript 244, 245
SQL 26
Strings
evaluating in functions
255
limiting size of 264
storing complex data in 353
StructClear CFML function 130
StructCopy CFML function 130
StructCount CFML function 129
StructDelete CFML function 130
StructFind CFML function 129
StructInsert CFML function 127
StructIsEmpty CFML
function
129
StructKeyArray CFML
function
129
StructKeyExists CFML
function
129
StructKeyList CFML function 129
StructNew CFML function 127
StructUpdate CFML function 128
Structured Query Language. See
SQL
Structures
about
125
adding data to 127
copying 130
creating 127
custom tag 177
deleting 130
example 130
finding keys 129
functions 133
getting information on 129
listing keys in 129
looping through 132
notation for 126
passing tag arguments 177
sorting keys 129
updating 128
sub tags
associating with the base
tag
180
definition 180
Submit buttons 42
SUBSTRING Search operator 294
SUM SQL function 73
Summaries, search 281
switch-case,CFScript 247
Syntax
checking
194
errors in CFML 195
expression 286
T
Tables
displaying queries
49
using HTML 49
Tag Wizard, using 401
Tags, context information 206
Testing
a variable’s existence
47
query parameters 94
Text control 41
Text files
column headings
335
creating queries from 335
delimiters 335
Text, displaying 12
throwOnTimeout, cflock
attribute
235
Time zone processing, WDDX 347
time-out attribute, cflock 235
Transferring data, from browser to
server
350
cftree tag
See also Tree controls
Tree controls, structuring
150
Troubleshooting 195
U
UNIX
C++ debuggers
403
permissions 323
Updating
a database with
cfgridupdate
159
a database with cfquery 160
a structure with cfset 128
a structure with
StructUpdate
128
data using forms 106
files 233
values in structures 128
Uploading files 319
Uploads, contolling file type 321
URLEncodedFormat CFML
function
195
URLs, specifying links from
graphs
77
User authentication
cfauthenticate tag
359
cfimpersonate tag 362
example 364
IsAuthenticated CFML
function
360
User edits, returning 156
User-defined functions. See Custom
functions
Users, keeping track of
221
V
Validating
at runtime
194
code 194
data types 90
form attributes 139
form field data types 91
form input 149
JavaScript functions 144
queries 94
user input 91
using regular expressions 140
Validation, error handling 144
var, CFScript statement 251
Variables
about
13
Application 230
Application scope 215, 230
application-level 216
Attributes scopes 174
caching 226
Caller scope 174
CfScript 245
Client scope 214, 221
configuring Client 223
default 88, 89, 219
defining 12
displaying 12, 14
ensuring existence of 88
evaluating 215
Form 14, 45
formatting 50
forms 40
in Custom functions 252
local 14
locking example 238
naming 179
passing 332
processing 40
Request scope 174
scope of 13
scopes for custom pages 174
sending 337
Server 232
Server scope 215
Session scope 214, 221, 228,
229
setting default values 89
testing for existence 47, 88