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

Updating the Database

Now that we have the form page out of the way, we can look at the action page. The action page we create will need to be able to take the information passed to it by our form and use it to update a particular record in our database.

Using ColdFusion, there are two ways we can accomplish this. One way is to use a SQL statement to update the database. Instead of using the SELECT keyword, we will use another keyword called (wait for it) UPDATE. The other way to affect a database update is to use the <CFUPDATE> tag. Because we all want to be clever little monkeys, we are going to look at both methods.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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