Programming instructions

138 Lesson 6 Adding and Updating SQL Data

For more information about adding data to a database using the cfupdate tag, see

Developing ColdFusion MX Applications with CFML.

Now that you have built the data entry form adding new and updating existing trips, you

will add the logic to link it to the main trip page to test the update logic.

Linking the Trip Edit page to the main page

As discussed in Lesson 4, the action page for the maintenance buttons on the main page

is maintenanceaction.cfm

. You previously added code for the Search and Delete buttons.

In the next exercise you will insert the code to call tripedit.cfm from maintenance.cfm as

follows:

</cfif>

Notice that when the user clicks the Add button, the maintenanceaction.cfm navigates to

tripedit.cfm passing no arguments. Conversely, when the user clicks the Edit button, the

Trip Edit page passes the current record id. The Trip Edit page must handle both cases.

When a

RecordID is passed on the URL, tripedit.cfm must query the database and fill

the form with the data for the corresponding trip. The following code properly initializes

the trip edit form:

SELECT tripName, eventType, tripDescription, tripLocation,

departureDate, returnDate, price, tripLeader, photo, baseCost,

numberPeople, depositRequired, tripID

FROM trips

WHERE tripID = #ID#

</cfif>

</cfquery>