MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manual de Instruções Página 139
- Página / 154
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
129
LESSON 6
Adding and Updating SQL Data
In this lesson, you will complete the Compass Travel Trip Maintenance application. The
exercises will guide you through the steps of adding the database update logic to add new
trip offerings and update existing trips in the Compass Travel database.
This lesson explains how to do the following tasks:
• Modify the Trip Edit page to link the add and update functions to the main
application page.
• Write code to insert new trips using SQL.
• Write code to insert new trips without using SQL.
• Write code to update several records in the Trips table.
ColdFusion tags and functions introduced in this lesson
The following table identifies the ColdFusion tags and functions that you use in this
lesson to enhance the ColdFusion application:
Element Type Description
cfinsert Tag Inserts records in a JDBC data source.
cfupdate Tag Updates a records in a JDBC data source.
- 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
Manuais e produtos relacionados com Servidores MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER
(60 páginas)Asus D510MT G9646 manuals
Owner’s manuals and user’s guides for Laptops Asus D510MT G9646.
We providing 1 pdf manuals Asus D510MT G9646 for download free by document types: User Manual
Comentários a estes Manuais