Multiple Delete of Records Part 1

Multiple Delete of Records (Part1)

This tutorial will show you how to delete multiple records using the SQL feature WHERE IN.

By using this SQL statement we can identify a set of records and use them to do a operation in the database. In the first part we will handle the deletion of records.

An example of this would be:

DELETE FROM TableName
WHERE ProdID IN (5, 6, 7)

This statement would delete the records with the id's 5, 6 and 7.

Now that we know this, we are going to use a form to display the records and collect the records that we want to delete by using checkboxes.

First of all we are going to make this form based on the following table:

This is a table with links.

Step 1: Creating the recordset and the form

We will call the page Default.asp and the form would look something like this:

The checkbox will have as Dynamic Attribute the ID of the table, in this case SCAT as checked value, so the link that we check will have the unique ID of the table in it as it's value.

.

We will name this checkbox "Delete" for purposes later on.

Apply a repeated region to the records that you want to be displayed and optional you can add navigation info and links.

And of course a submit button to POST the form to the page where we will delete the selected records. We will call this page Delete.asp.

To avoid a cache page when we return from the delete page we put a NO CACHE in this page, so we will see the new recordset without refreshing the page.

Go to Step 2 >>