欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

网络寻呼机数据库版删除选中的消息deletemessage.asp

程序员文章站 2022-10-31 17:51:51
<% response.buffer=true %> <% response.buffer=true %>
<html>

<head>

<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>删除消息</title></head>

<body>
<%

id=request("id")
id=split(id,",")
page=clng(request("page"))

set conn = server.createobject("adodb.connection")
    provider = "provider=microsoft.jet.oledb.4.0;"
    dbpath = "data source=" & server.mappath( "webuser.mdb" )

    conn.open provider & dbpath
    
    for i=0 to ubound(id)
        sql="delete from talks where id="&id(i)
        conn.execute(sql)
    next
    
    
    conn.close
    set conn=nothing
    response.redirect"history.?page="&page
%>
</body>

</html>