火灾伤亡统计:ASP删除记录

来源:百度文库 编辑:高校问答 时间:2024/04/28 04:34:44
<!--#include file="conn.asp" -->
<%
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from site"
rs.open sql,conn,1,3
%>

<table border=1 width=770>
<tr>
<td align=center>名称</td>
<td align=center>地址</td>
<td align=center>说明</td>
<td align=center>操作</td>
</tr>
<%do while not rs.eof%>
<%
sitename=rs("sitename")
siteurl=rs("siteurl")
sitesay=rs("sitesay")
%>
<tr>
<%id=rs("id")%>
<td align=center><%=sitename%></td>
<td align=center><%=siteurl%></td>
<td align=center><%=sitesay%></td>
<td align=center><a href="linkdel.asp?=<%=id%>">删除</a></td>
</tr>
<%
rs.movenext
loop
%></table>
---------------------------------------------------------------
<!--#include file="conn.asp" -->
<%
response.write"dfd"
set rs = Server.CreateObject("ADODB.Recordset")

conn.execute "delete from site where sitename='"&trim(request.querystring("id"))&"'"

response.redirect "linkmanage.asp"
%>
为什么不删除

delete from site where sitename写成
delete site where sitename