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

Day 7. Changing the Contents of a Databa... > Introducing <CFINSERT> and <CFUPDATE...

Introducing <CFINSERT> and <CFUPDATE>

You'll need to understand two new ColdFusion tags to create the new pages, <CFINSERT> and <CFUPDATE>. Both are used when you want to change the information in a database. Both work like SQL queries in reverse—instead of selecting information from a database table, these tags change or add values to the fields you specify.

Use <CFINSERT> when you need to add a new record to an existing table. It doesn't require any qualifying statements to do its work. It simply takes the variables you've defined, matches them with field names in your table, and inputs the lot as a new record.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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