MACROMEDIA COLDFUSION MX 61-CFML Informations techniques télécharger pdf (Page 78)

78 Chapter 7: Lesson 4: Building Dynamic Queries

</cfquery>

</cffunction>

Add the highlighted code to the cfquery block to use the dynamically built WHERE clause in

the query:

SELECT tripID, tripName, tripLocation, departureDate,

returnDate, price FROM trips

WHERE #PreserveSingleQuotes(WhereClause)#

</cfquery>

Save the file.

Let Dreamweaver do it

You can use the Dreamweaver Extensions to create the CFC query.

To construct the query with Dreamweaver:

Click the Bindings tab.

Click the + button.

Select Record set (Query).

In the Name text box, enter Tr i p R e s u l t .

Click the New Function button.

In the New function name text box, enter getTripsFromForm and click OK.

From the Data source list, select CompassTravel.

From the Tables list, select trips.

Click the Selected radio button.

10.

Select tripName, tripLocation, departureDate, returnDate, price, and tripID.

11.

Click OK.

12.

Return to Step 3 in the “To add the new query to the CFC:” section.

1 2 ... 73 74 75 76 77 78 79 80 81 82 83 ... 151 152

Pas de commentaire

MACROMEDIA COLDFUSION MX 61-CFML Informations techniques Page 78