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

Lesson 6. Modifying Databases

Lesson 6. Modifying Databases

Having the power to retrieve information from a database is significant in and of itself; having control over the information in the database increases this strength. The power to add or change information in a database makes an already dynamic application even more effective.

Using ColdFusion, you can add, update, or remove records from a database. This ability ensures that the information in your database stays up to date and is always accurate. For example, if you have a product catalog in a database and you need to raise the price of an item, you can use a Web interface with ColdFusion to go in and edit the price of that particular item, or any item, and it is updated throughout the site immediately. If you needed to remove a customer from the database or update their information, this, too, can all be done through a Web interface. This saves you from having to “physically” open the database and change records. All of these options give you better control over your site's dynamic content and the information critical to its operation.

The database plays one of the most important roles in your online process. The ability to insert, update, and delete (as well as retrieve) information from the database makes it the centerpiece of your application.

In this lesson you will be adding, updating, and removing items from the product database for the Wireless Agent Web site. This ability allows you to keep the product database content fresh and up to date.

WHAT YOU WILL LEARN

In this lesson, you will:

  • Insert records into a database

  • Update records in a database

  • Delete records from a database

APPROXIMATE TIME

This lesson takes approximately 1 hour and 30 minutes to complete.

LESSON FILES

Starting Files:

Lesson6\Start\productinsertform.cfm

Lesson6\Start\productupdateform.cfm

Lesson6\Start\productmenu.cfm

Completed Files:

Lesson6\Complete\productinsertform.cfm

Lesson6\Complete\productinsert.cfm

Lesson6\Complete\productupdateform.cfm

Lesson6\Complete\productupdate.cfm

Lesson6\Complete\productdelete.cfm


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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