MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Instruction Manual download pdf (Page 144)

134 Lesson 6 Adding and Updating SQL Data

7 Click Search.

The TripResults page appears:

8 Click the link to the NH White Mountains to display the details of the trip you just

added. Verify that all the fields were saved correctly.

The following page appears:

9 Click the Delete button to delete this record so that you can reuse the steps 4-8 of this

exercise in the next exercise.

1 2 ... 139 140 141 142 143 144 145 146 147 148 149 ... 153 154

CONTENTS 3
ABOUT THIS BOOK 7
Developer resources 8
Getting answers 10
Contacting Macromedia 10
Welcome to ColdFusion 11
CHAPTER 1 13
Introducing ColdFusion MX 13
The Internet 14
Intranet applications 15
Web servers 15
Web pages 15
Web browsers 16
What is ColdFusion MX? 18
• Tags that begin with cf 19
• ColdFusion data sources 20
• Debugging output 20
• Server settings 20
• Application security 20
CHAPTER 2 23
CFML Basics 23
Working with ColdFusion pages 24
Understanding CFML elements 26
Functions 27
Functions and parentheses 28
Nesting functions 28
Functions and pound signs 28
Variables 29
Displaying variable output 30
Working with CFML expressions 31
Arithmetic operators 34
String operator 34
Processing form data 36
Commenting your code 38
CHAPTER 3 39
Database Fundamentals 39
Understanding database basics 40
About SQL 42
Using SQL with ColdFusion 43
CHAPTER 4 45
Configuring Your Development 45
Environment 45
Enabling debugging options 50
To enable debugging options: 51
Dreamweaver 53
MX window 53
Building a ColdFusion 57
Application 57
LESSON 1 59
Preparing to Build the Sample 59
Recognizing the data types 63
How to proceed 65
LESSON 2 69
Writing Your First ColdFusion 69
Sorting the results 74
Creating a dynamic web page 76
• tripID 80
• price is 5000 80
• price less than 600 80
• price greater than 1500 80
3 To build the 88
LESSON 3 91
Reviewing the code 105
In the next lesson 108
LESSON 4 109
in a cfif 114
• For MS Windows systems: 126
Implementing the Browsing and 129
LESSON 5 129
Page flow 130
Navigation action page 130
Application development steps 131
maintenance action page: 134
SQL DELETE Statement 135
LESSON 6 139
Adding and Updating SQL Data 139
SQL Update 150
Updating multiple records 151

Comments to this Manuals

No comments

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Instruction Manual Page 144

Comments to this Manuals

Related products and manuals for Servers MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER