Tutorial/asp 10 days to learn the seventh day of ASP

Learning Objectives: Learn the basic operation of the database 3 (delete records)

Straight to the point, everyone directly to see the program.
exec= "Delete * from guestbook where id=" &request.form ("id")

The above sentence completes the operation of deleting records, however, the lock record with the record unique ID, we set up the database in front of the system to our primary key, the name is number, because the name is not very convenient, we can modify the ID, do not modify the words is

exec= "Delete * from guestbook where number =" &request.form ("id")

Here we look at the complete code: a form passed to the ASP file an ID, and then this ASP file deleted this ID.

Delete

example7.asp:

I added a example72.asp in the example, and example4.asp almost, is added an ID field, you can run this file to see the ID of all the records and want to delete the record ID, delete records can also be reviewed through this file. By the end of the day, we will integrate all these things. Everyone would not need such a cumbersome operation.

example72.asp: