Active Server Pages 3.0 from Scratch

Storing myLinks Information in the Database

The links table is pretty simple, so let's take a look at it first. We're going to need the ability to do three things: insert, update, and delete records.

We're going to start by creating a form that will list all of the current records, along with a check box to mark them for deletion. We'll also have a link to a form where we can edit the record and a link that will give us to a blank form we can use to create a new one.

Copy admintemplate.asp to edit_links.asp. Add the code in Listing 8.6.

Code Listing 8.6. edit_links.asp: Deciding which records to edit or delete

0: <%@ LANGUAGE="VBSCRIPT" %> 1: <!--#include file="adovbs.inc"--> 2: <!--#include file="pagetop.txt"--> 3: <!--#include file="isadmin.inc"--> ...