• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 12. Using Advanced Form Techniques t... > Understanding SQL Updates, Inserts, ...

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint