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

Summary

Forms are your users'link to the inner workings of your sites. By mastering their advanced incarnations, you can build truly interactive sites. In Day 7, you first learned how to change the contents of a database by using forms in conjunction with <CFUPDATE> and <CFINSERT> tags in your ACTION pages. Today's lesson introduced you to three SQL commands that pick up where ColdFusion's basic tags leave off: UPDATE, INSERT, and DELETE.

The first two of these are used in place of their ColdFusion equivalents when data to be added comes from sources other than a form. The third, DELETE, is unique to SQL and has no corresponding tag in CFML. DELETE is used to delete records from a database table, and should always be used with extreme caution.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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