Thomas Wallace: Lectures and Resources - A collection of website design lectures and resources

Creating the Insert Record page

1. Create a new Dynamic page (ASP VBScript) and save it as insert.asp
2. Create a new recordset using the same settings as we used for the email.asp page. After you create the recordset the Application palette should look like this.
   
3. From the menu at the top of Dreamweaver select Insert > Application Object >Insert Record > Record Insertion Form Wizard

4. In the Record Insertion Form Dialog Box use the following settings

• Connection: ITLemon_Email
• Insert into Table: StudentEmail
• After inserting, go to: email.asp
• Form Fields:
  • Move FirstName to the top of the List (Highlight and press the up arrow)
  • Move LastName to the second position
  • Move Email to the third Position
  • Highlight StudentId and hit the Minus key to remove it from the list
• You can rename the labels for each column if you wish
5. Hit Ok
6. Your Page Should now look something like this

7. Save the page and upload both the email.asp and insert.asp to the server
8. Try it out.