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

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.