Products & Services

• What's Hot
• Compare All Plans
• Web Hosting
• Domain Names
• Email & Collaboration
• Site Building & Marketing
• Ecommerce & Security
• Support & Infrastructure
• Additional Services
• Reseller Program
• Training & Certification
• Systems Integration
• Help Desk

Updating data in a database using ASP

To modify data inside a MS Access, or MS SQL database, you must use the update SQL statement. We have found that it is much easier to use a 3 form method to update data. First, you would select the data to modify based upon a unique identifier. In this example, we have use the 'name' field. We're assuming that this field would be unique for all records inside our database. You may want to use something like SKU, or PartID for your use. The second page will pull the data for the record that was selected from the first page. The final page will update the database based upon what changes you made on the second page.

Here's how it works:

• First, copy modify1.asp.txt, modify2.asp.txt, and modify3.asp.txt
• Rename them to modify1.asp, modify2.asp and modify3.asp
• Edit the script appropriately for the design of your database. Remember, we have assumed that you will have certain records and database design.
• Upload it to your Windows 2000 account
• Ensure you have an ODBC connection, with a DSN.