Introduction to ASP Programming (Twenty): Delete Data Records of ADO Components

1. First, we must clearly delete which record

It's nothing more than SQL statements, such as corresponding to a specific ID.

id = request.form("id")

sql = "Select * from cnarticle where cn_id="&id

Set rs = Server.CreateObject ("ADODB.Recordset")

rs.Open sql,conn,2,3

2. A very simple statement: delete

rs.delete

3. It is best to ask for confirmation of deletion before modification

<script language="JavaScript">

<!--

function suredo(src,q)

{

var ret;

ret = confirm(q);

if(ret!=false)window.location=src;

}

//-->

</script>

<a href='javascript:suredo("del.asp?id=<%=id%>","Confirm to delete?")'>Delete</a>

The most direct statement