Question

ASP删除记录

<!--#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" -->
<%
set rs = Server.CreateObject("ADODB.Recordset")

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

response.redirect "linkmanage.asp"
%>
怎么回事

Answer 1

楼主用的可是ACCESS数据库啊，请照下面的方式改一下就可以了
conn.execute "delete * site where id="&trim(request.querystring("id"))