Programming instructions

144 Index
syntax 18
URLEncodedFormat 81
H
HTML, defined 6
I
Internet
applications 4
defined 4
intranet
application 5
defined 5
IsDefined function, defined 81
J
JavaScript, described 6
M
Macromedia ColdFusion MX. See
ColdFusion MX
Macromedia Dreamweaver MX
configuring 45
defined 43
Macromedia Flash MX 11
Macromedia HomeSite+,
configuring 45
Microsoft Access, configuration 37
N
NFS, defined 4
Now function, defined 14
O
operators 23–24
P
PointBase, configuration 38
PreserveSingleQuotes function,
defined 59
primary key, defined 54
Q
query
building 66
results, displaying 65
search operators 70
variables 91
R
relational database, defined 30
S
sample application. See tutorial
search
capability, developing 69
results page, building 73
SQL
commands 32
data source 33
described 32–33
INSERTstatement 130
ORDER BY 64
security risks 88
SELECTstatement 62
WHERE clause 63
writing statements 33
T
tags
attributes 17
cfform 99
cfif 59
cfinput 99
cfinsert 129
cflocation 119
cfoutput 59
cfquery 59
cfselect 99
cfset 59
cfupdate 129
defined 16–17
syntax 16
Telnet, defined 4
tutorial
adding and updating SQL
data 129–142
application business rules 103
application defined 55
application page flow 120
application requirements 51
creating main application
page 81–98
data requirements 52
database configuration 37
database design 53
enforcing business rules 99–117
file structure, described 36
implementing browsing and
maintenance
functions 119–128
linking pages 125
preparing 49–57
requirements 57
validating trip photo 115
working directories 56
U
URL structure, defined 119
URLEncodedFormat function,
defined 81
URLs, described 7
V
variables
creating 19
defined 19–21
displaying output 20
naming 19
query 91
scope 20
W
web application servers,
described 7–8
web browsers, defined 6
web pages, defined 5
web server, described 5
web servers, defined 5
WWW, defined 4