Manuel D’UtilisationTable des matièresContents3Introduction7About Macromedia ColdFusion MX 7 documentation7Documentation set7Viewing online documentation8Welcome to ColdFusion9Introducing ColdFusion MX11Contents11About ColdFusion MX11The ColdFusion application server11The ColdFusion Markup Language12The ColdFusion MX Administrator12How ColdFusion processes pages12Building applications with CFML13Interacting with data sources13Interacting with mobile devices13Development tools13CFML Basics15Contents15Working with ColdFusion pages15Creating a ColdFusion page16Saving your ColdFusion page17Browsing your code17About CFML elements18Tags18Functions19Variables21Naming variables21Ways to use variables21Creating variables with the cfset tag21Displaying variable output23Working with CFML expressions23Building expressions24Specifying a consistent character case24Specifying number signs to denote functions or variables24Specifying quotation marks around values25Specifying operators in expressions25About conditional processing27Using the cfif tag to evaluate True or False conditions27Using the cfelseif tag to evaluate multiple expressions28Processing form data28Commenting your code30Database Fundamentals31Contents31About database basics31What is a relational database?32About relational tables33About SQL34Understanding basic SQL SELECT statements34Using the SQL WHERE clause to limit the rows returned35Sorting the results36Using SQL with ColdFusion36About data sources36Writing SQL and CFML statements to interact with a data source37CFML tags that interact with a database37Building a ColdFusion Application39Lesson 1: Preparing to Build the Sample Application41Application development steps41Exercise 1: Determining the application functional requirements42Exercise 2: Determining the data requirements43Exercise 3: Designing the database for your application43Exercise 4: Developing the sample application46How to proceed47Working directories47Requirements48Lesson 2: Configuring Your Development Environment49Exercise 1: Verifying the tutorial file structure49Exercise 2: Setting up your development environment50About Macromedia Dreamweaver MX50Features for ColdFusion developers51Configuring Dreamweaver MX for ColdFusion development51Exercise 3: Configuring a database connection52Using Dreamweaver to configure a data source52Configuring a data source in the Administrator52Configuring the connection to the sample database file53Exercise 4: Configuring debugging options55Viewing debugging information within Dreamweaver55Enabling debugging in the ColdFusion MX Administrator55Sending debugging information to remote clients57Summary57In the next lesson57Lesson 3: Retrieving Data59Exercise 1: About the trip list60Exercise 2: Retrieving the information for the trip list61Exercise 3: Displaying the query result using the cfoutput tag62Displaying the column contents from the SQL statement62Exercise 4: Writing structured, reusable code63Creating the CFC file63Copying the query to the CFC65Calling the query method65Exercise 5: Creating additional queries66Creating the query66Invoking the new method68Displaying the results68Summary69In the next lesson69Lesson 4: Building Dynamic Queries71Exercise 1: Creating the trip search form71About the trip search form71Designing the search criteria page72Understanding search query operators73Creating the Trip Search page73Exercise 2: Building a query that uses dynamic SQL75Building the WHERE Clause with the cfif and cfset tags76Creating the CFC query77Exercise 3: Constructing the initial Trip Search Results page79Exercise 4: Testing the Trip Search Results page81Exercise 5: Enabling the departure and price criteria on the Trip Search form82Exercise 6: Testing the revised Trip Search Results page83Summary83In the next lesson83Lesson 5: Creating a Trip Detail Page85Exercise 1: Creating a Trip Detail page86Building the Trip Detail page86Exercise 2: Avoiding the potential security risk when using dynamic SQL91Protecting your application92Exercise 3: Linking the Trip Search Results page with the Trip Detail page92Exercise 4: Enhancing the look of the Trip Search Results and Trip Detail pages93Formatting dates and dollar amounts93Summary95In the next lesson95Lesson 6: Creating a Main Application Page97Exercise 1: Creating the main application page from the Trip Detail page98Adding navigation buttons to browse the database98Exercise 2: Adding database maintenance buttons100Summary101In the next lesson101Lesson 7: Validating Data to Enforce Business Rules103Exercise 1: Using an HTML form to collect data104Exercise 2: Creating a simple action page107Exercise 3: About data validation108Exercise 4: Providing server-side validation109Creating a local variable109Ensuring that a value was entered110Evaluating check box and radio button variables111Adding validation for all Compass Travel business rules111Exercise 5: Validating data on the client using ColdFusion form tags114Comparing server-side and client-side validation114Modifying the Trip Edit page to use ColdFusion form tags116Exercise 6: Dynamically populating the list of event types119Exercise 7: Validating the existence of the trip photo file120Summary122In the next lesson122Lesson 8: Implementing Browsing and Searching123Exercise 1: Enabling users to browse trip details123Using dynamic SQL to browse the Trips table124Limiting the number of result rows125Exercise 2: Determining actions based on which button a user clicks127Exercise 3: Enabling searching from the Trip Detail page127Summary128In the next lesson128Lesson 9: Enabling Database Maintenance129Exercise 1: Deleting the current trip record shown on the Trip Detail page129Exercise 2: Adding trips with SQL INSERT statements131Exercise 3: Adding data using the cfinsert tag135Exercise 4: Updating a SQL row using the cfupdate tag137Exercise 5: Linking the Trip Edit page to the main page138Exercise 6: Inserting values in the edit form139Summary142Lesson 10: Restricting Access to ColdFusion Applications143Exercise 1: About the Login Wizard143Installing the Login Wizard143Preparing to run the Login Wizard144Creating an application that includes user authentication144Adding user authentication to an existing application145Starting the Login Wizard145Creating a login using simple authentication146Creating a login using LDAP authentication146Creating a login using Windows NT authentication147Exercise 2: Requiring users to log in to the Compass Travel application147Summary148Index149Taille: 1,9 MoPages: 152Language: EnglishOuvrir le manuel
