I l @ ve RuBoard |
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:
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 |
I l @ ve RuBoard |