O'Reilly logo

Sams Teach Yourself ColdFusion® in 21 Days by Charles Mohnike

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding SQL Updates, Inserts, and Deletes

Way back in Day 5, "Finding the Data You Need: An Introduction to Queries and SQL," you learned how to use the <CFUPDATE> and <CFINSERT> tags to edit and add records in a database. For simple sites, these tools work fine—they enable you to take user data from a form and perform some action on your database. But as your knowledge of ColdFusion grows and your applications become more sophisticated, you might find that you need more flexibility in working with your database. Take a look at Figure 12.1 for a basic example.

Figure 12.1. A basic input form that collects data from the user.

To input this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required