Question

asp不能删除数据库记录

下面的代码数据库连接没问题，就是删除不掉记录，也不报错
liuyantimu 是前一个页面传过来的值

liuyantimu=request.querystring("liuyantimu")
set con=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
dbpath=server.mappath("data/nyc8318.mdb")
con.open "driver={microsoft access driver (*.mdb)};dbq=" & dbpath
sql="delete * from wenzhan where 题目='"& liuyantimu & "'"
rs.open sql,con ,1,3
set uplist=con.execute(sql)
%>
<%Response.Write "信息成功删除!"%>

Answer 1

rs.open sql,con ,1,3
set uplist=con.execute(sql) 修改为
rs.open sql,con ,3,3
rs.delete

Answer 2

conn.execute("delete from wenzhan where 题目='"& liuyantimu & "'")
有这一句就OK了。