为什么删除不了ACCESS数据库中的记录!!!
来源:百度知道 编辑:UC知道 时间:2024/06/13 02:27:11
<%
set rs = Server.CreateObject("ADODB.Recordset")
conn.execute "delete khxx where NO="&trim(request.querystring("NO"))
response.redirect "kehulist.asp"
%>
<%
rs.close '关闭记录集
set rs=nothing '释放资源
%>
set rs = Server.CreateObject("ADODB.Recordset")
conn.execute "delete khxx where NO="&trim(request.querystring("NO"))
response.redirect "kehulist.asp"
%>
<%
rs.close '关闭记录集
set rs=nothing '释放资源
%>
试试
conn.execute("delete khxx where NO='"&trim(request.querystring("NO")) &"'")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("数据库地址")
exec="delete khxx where NO="&trim(request.querystring("NO"))
conn.execute exec
你的conn定义错了