Programming instructions

ManualsBrandsMACROMEDIA ManualsComputer equipmentCOLDFUSION 5 - INSTALING AND CONFIGURING SERVER

121

122

123

124

125

126

127

128

129

130

Developing code to validate data and enforce business rules 111

<tr>

<td valign="top">Type of Event

</td>

<td>

<cfselect size="1" name="eventType" required="Yes"

message="Type of event must be selected.">

#GetEvents.eventType#

</option>

</cfoutput>

/cfselect>

</td>

</tr>

Exercise: use eventtypes table to load event types

Do the following steps to modify the Trip Edit page to display a list of event types from

the eventtypes table and add validation.

To display a list of event types from the eventtypes table and add validation:

1 View the tripedit.cfm page in a browser. Select the event types drop-down list. Notice

that only three event types appear in the list.

2 Open the tripedit.cfm in the my_app directory in your editor.

3 Add the following code above the <html> tag:

SELECT eventType, eventTypeID

FROM eventtypes

</cfquery>

4 Replace the following eventtypes code lines:

<cfselect size="1" name="eventType" required="Yes"

message="Type of event must be selected.">

<option value="1" selected>Surfing</option>

<option value="2">Mountain Climbing</option>

<option value="3">Mountain Biking</option>

</cfselect>

with these lines:

<cfselect size="1" name="eventType" required="Yes"

message="Type of event must be selected.">

#GetEvents.eventType#

</option>

</cfoutput>

</cfselect>

5 View the tripedit.cfm page in a browser. Select the event types drop-down list. Notice

that all seven event types appear in the list.