How do I delete a record from a database using ASP?

If you are trying to delete a record (row) from a database using ASP, you will need to create a record set that queries the row from the database and then delete the record set, as shown here:

set conn = server.createobject("ADODB.Connection");
conn.open "DSN name";

set recordset = server.createobject("ADODB.Recordset");
recordset.open("Select * from table where ID=1");
recordset.delete();
recordset.update();