MACROMEDIA COLDFUSION MX 61-CFML Informações Técnicas Página 82
- Página / 152
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
82 Chapter 7: Lesson 4: Building Dynamic Queries
3.
Verify that the other criteria (departure date and price) are not taken into consideration yet as
follows:
a
Click the Back button in the browser to return to the Trip Search page.
b
In the Departure Date drop-down list box, select Before, enter 1/1/1900 as the date, and
select Smaller Than 0 for the price.
Either of these conditions would produce a results page with no rows.
c
Click the Search button.
The Trip Search Results page should be identical to the one in Step 2, because the code to
build the WHERE clause in the Trip Search Results page does not include departure date
and price.
Exercise 5: Enabling the departure and price criteria on the Trip
Search form
In this exercise, you will modify the Trip Search Results page to add the criteria needed for the
departure and price query.
To enable the departure and price criteria:
1.
Open the gettrips.cfc file.
2.
In the getTripsFromForm method, position the pointer before the cfquery code block.
3.
To build the departureDate WHERE subclause, enter or copy and paste the code in the
following table immediately before the
cfquery code block:
For this database Enter this code
(Windows users)
Microsoft Access
database file
<!--- Build subclause for departureDate --->
<cfif Form.departureValue GT "">
<cfif Form.departureOperator EQ "EQUALS">
<cfset WhereClause = WhereClause & " and departureDate = " &
CreateODBCDate(Form.departureValue)>
<cfelseif Form.departureOperator EQ "AFTER">
<cfset WhereClause = WhereClause & " and departureDate > " &
CreateODBCDate(Form.departureValue)>
<cfelseif Form.departureOperator EQ "BEFORE">
<cfset WhereClause = WhereClause & " and departureDate < " &
CreateODBCDate(Form.departureValue)>
</cfif>
</cfif>
(UNIX users)
PointBase database
file
<!--- Build subclause for departureDate --->
<cfif Form.departureValue GT "">
<cfif Form.departureOperator EQ "EQUALS">
<cfset WhereClause = WhereClause & " and departureDate = Date '" &
Form.departureValue & "'">
<cfelseif Form.departureOperator EQ "AFTER">
<cfset WhereClause = WhereClause & " and departureDate > Date '"
& Form.departureValue & "'">
<cfelseif Form.departureOperator EQ "BEFORE">
<cfset WhereClause = WhereClause & " and departureDate < Date '" &
Form.departureValue & "'">
</cfif>
</cfif>
- COLDFUSION 1
- CONTENTS 3
- Contents 5 5
- 6 Contents 6
- INTRODUCTION 7
- 8 Introduction: 8
- Welcome to ColdFusion 9
- CHAPTER 1 11
- Introducing ColdFusion MX 11
- • Debugging output 12
- • Server settings 12
- • Application security 12
- • ColdFusion data sources 12
- CHAPTER 2 15
- CFML Basics 15
- 16 Chapter 2: CFML Basics 16
- To view the ColdFusion page: 17
- About CFML elements 18
- Tag attributes 19
- Functions and number signs 20
- Functions and parentheses 20
- Using functions on values 21
- Nesting functions 21
- 22 Chapter 2: CFML Basics 22
- 24 Chapter 2: CFML Basics 24
- Arithmetic operators 26
- About conditional processing 27
- Processing form data 28
- Commenting your code 30
- CHAPTER 3 31
- Database Fundamentals 31
- Field (column) 32
- About database basics 33 33
- About SQL 34
- About SQL 35 35
- Using SQL with ColdFusion 36
- Using SQL with ColdFusion 37 37
- CHAPTER 4 41
- Sample Application 41
- Recognizing the data types 44
- CHAPTER 5 49
- Lesson 2: Configuring Your 49
- Development Environment 49
- The appended debugging 56
- The application form 56
- Summary 57 57
- CHAPTER 6 59
- Lesson 3: Retrieving Data 59
- Summary 69 69
- CHAPTER 7 71
- • Price is 5000 73
- • Price less than 600 73
- • Price greater than 1500 73
- ■ The SQL keyword AND 76
- Search form 82
- Summary 83 83
- CHAPTER 8 85
- Detail page 92
- Trip Detail pages 93
- Summary 95 95
- CHAPTER 9 97
- Reviewing the code 100
- Summary 101 101
- CHAPTER 10 103
- Business Rules 103
- To test the validation code: 114
- ■ For MS Windows systems: 121
- CHAPTER 11 123
- CHAPTER 12 129
- INSERT INTO table_name 131
- VALUES (value1, value2,....) 131
- Save the file 133
- CHAPTER 13 143
- ColdFusion Applications 143
- <cfinclude 144
- To start the Login Wizard: 145
- Access must be RDS 145
- To test the authentication: 148
- 150 Index 150
- Index 151 151
- 152 Index 152
Manuais e produtos relacionados com Software MACROMEDIA COLDFUSION MX 61-CFML
(17 páginas)LOEWE 52434U85 manuels
Manuels d'utilisation et guides de l'utilisateur pour Télévisions LED LOEWE 52434U85.
Nous fournissons des manuels en pdf 1 LOEWE 52434U85 à télécharger gratuitement par type de document : Fiche technique
Comentários a estes Manuais