MACROMEDIA COLDFUSION MX 61-CFML Información técnica descargar pdf (Pagina 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

Sin comentarios

MACROMEDIA COLDFUSION MX 61-CFML Información técnica Pagina 78