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 ...