User Guide

130 Chapter 10: Lesson 6: Adding and Updating SQL Data
Summary
In this lesson you used the
cfinsert and cfupdate tags to add and update data to a SQL table.
You also have used the SQL UPDATE statement in conjunction with the
cfquery tag to effect a
trip price increase for all rows in the Trips table.
You have completed the Getting Started tutorial. You should understand how you can combine
CFML and SQL to develop powerful applications. When compared with traditional
development methods, ColdFusion helps speed the development in hand crafting a database
solution like the one in this tutorial. Remarkably, however, depending on the editor or IDE that
you use to develop applications, much of the work in this tutorial can be autogenerated using
built-in wizards, which simplifies the development process even more.