Programming instructions

ManualsBrandsMACROMEDIA ManualsComputer equipmentCOLDFUSION 5 - INSTALING AND CONFIGURING SERVER

141

142

143

144

145

146

147

148

149

150

136 Lesson 6 Adding and Updating SQL Data

The cfinsert tag used in the previous code snippet uses the following attributes:

Exercise: insert trip data using cfinsert

In this exercise, you change the approach the action page uses to insert the data into the

database. You will replace the SQL INSERT statement with the

cfinsert tag.

To add data using cfinsert:

1 Open tripeditaction.cfm from the my_app directory in your editor and do the

following:

a Remove the entire AddTrip cfquery that you added in the last exercise (from the

beginning

<cfquery name ="AddTrip" datasource="CompassTravel"> tag to

the

</cfquery> end tag).

b Add the following

cfinsert tag to insert data into the trips table in the same

location as the code that you just deleted:

2 Save the page and test it by opening the tripedit.cfm page in your browser.

3 Follow steps 4 through 9 in the previous exercise to verify this approach to inserting

new trips.

For more information about adding data to a database using the

cfinsert tag, see

Developing ColdFusion MX Applications with CFML.

Updating a SQL row using cfupdate

To update an existing SQL row, ColdFusion offers a simple approach for updating SQL

rows through the use of the

cfupdate tag. Like cfinsert, the cfupdate tag has

datasource and tablename attributes to specify where the data is to be inserted. The

tag also has a

formfields attribute to identify which fields are to be inserted.

Formfields is a comma-separated list of form fields to insert. If this attribute is not

specified, all fields in the form are included in the operation.

All the fields of the tripedit.cfm page have corresponding columns in the Trips table, so

you can omit the

FormFields attribute for both the cfinsert and cfupdate tags. If the

tripID form field is passed from the TripEdit page the cfupdate tag is used otherwise the

cfinsert tag is executed. The following example uses the cfupdate and cfinsert

without the

FormFields attribute:

Attribute Description

datasource The data source name associated with the database where the data is

inserted.

tablename The name of the SQL table within the database where the data are

inserted.

formfields A comma-separated list of form fields to insert.