System information

150 Index
conditional processing 27, 28, 76, 82
contains operator 73
context root 17
creating
action pages 107
CFCs 64
cross-field edits 108
currency, formatting 93
D
data sources
defined 36
supported 13
data types, recognizing 44
data validation
about 108
client-side 115
server-side 109
data, retrieving 61
databases
browsing records 123
CFML tags 37
connecting to 53
data types 44
designing 43
establishing table relationships 45
fields 32
fundamentals 31, 37
primary key 45
records 32
relational 32
tables 32
understanding 31
DateFormat function 16, 85
dates
displaying 66
formatting 93
debugging information, remote clients 57
debugging options, enabling 56
debugging settings, described 55, 57
deleting records 129
development tools, described 13, 57
displaying
dates 66
query results 68, 88
search results 79
trip information 60
trips by price 66
variables 62
DollarFormat function, defined 85
Dreamweaver
creating CFC queries 67, 78, 87
creating CFCs 64
creating queries 61
Extensions 143
invoking methods 66, 67, 68, 80
Login Wizard 143
dynamic queries 75
dynamic SQL 75, 124
dynamically populating lists 119
E
editors, supported 15
enable searching 127
ends with operator 73
equals 73
expressions
building 24
character case 24
defined 23
denoting functions or variables 24
literal values 25
operators 25
quotation marks 25
F
FileExists function 103
foreign key, defined 45
form page, defined 28
form processing, defined 28, 29
formatting
currency 93
dates 93
forms 72
ColdFusion 116
for searching 73
HTML 73
inserting values in 139
trip edit 104
functions
DateFormat 16, 85
defined 19, 20
DollarFormat 85
FileExists 103
IsDefined 85
nesting 21
Now 16
operation on values 21
syntax 20
URLEncodedFormat 85