网络寻呼机数据库版删除选中的消息deletemessage.asp
程序员文章站
2022-05-18 15:09:34
<% 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>
<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>