MACROMEDIA COLDFUSION MX 61-CFML Información técnica Pagina 53
- Pagina / 152
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Exercise 3: Configuring a database connection 53
To access the ColdFusion MX 7 Administrator:
• Open a browser and go to one of the following URLs:
■ External web server users: http://localhost/CFIDE/administrator
■ Built-in web server users: http://localhost:8500/CFIDE/administrator
■ J2EE server users: http://localhost:portnumber/CFIDE/administrator. If you installed
ColdFusion Enterprise Edition with JRun, the default HTTP port is 8300.
Note: If you are accessing the ColdFusion MX Administrator from a remote client, you must replace
localhost with the host name or IP address of the computer where ColdFusion MX is installed.
The following sections describe how to establish a connection to the sample tutorial database file
and how to enable optional debugging settings.
Configuring the connection to the sample database file
The following procedures describe how to configure a connection to the sample database file
(CompassTravel) using the ColdFusion MX Administrator. Prior to building the sample
application, you must configure the Compass Travel database connection.
Perform one of the following procedures. The Microsoft Access procedure is for Windows users.
The PointBase procedure is for UNIX and Macintosh OS X users.
To define the connection to the sample Microsoft Access database:
1.
In the ColdFusion MX Administrator, select Data & Services > Data Sources.
2.
In the Data Source Name box, enter CompassTravel.
3.
In the Driver list, select Microsoft Access with Unicode.
4.
Click Add.
5.
Click Browse Server and navigate to the cf_root/cfdocs/getting_started/db/CompassTravel.mdb
file.
6.
Click Apply.
7.
Click Show Advanced Settings and ensure that the settings for CLOB and BLOB are enabled
(checked).
8.
Click Submit to complete the data source configuration.
The ColdFusion MX Administrator verifies the data source connection and the name
CompassTravel appears in the Connected Data Sources table.
9.
Ensure that OK appears in the Status column for CompassTravel.
If the connection to the CompassTravel data source fails, do the following:
a
Verify that the name of the data source file does not contain a space. If it does contain a
space, delete the data source from the Connected Data Source dialog box. To do this, click
the Delete action button associated with the CompassTravel data source name, and then
repeat the steps in this procedure to reconfigure this data source.
b
Verify that the path specified for the Compass Travel database file is correct.
- 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
Relacionado con productos y manuales para Software MACROMEDIA COLDFUSION MX 61-CFML
(17 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.041 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales