大家帮我看看吧
删除记录的错误
代码是:
<%
dim conn,rs
set conn=server.createobject("adodb.connection")
conn.open="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("../db/db1.mdb")
id=trim(request.Form("id"))
exec="delete from zhengshu where id="&id
rs.open exec,conn,1,2
%>
错误是:
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象: ''
/admin/zhengshu_del.asp,行 7
第7行是rs.open exec,conn,1,2
如果我改成:
<%
dim conn
set conn=server.createobject("adodb.connection")
conn.open="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("../db/db1.mdb")
id=trim(request.Form("id"))
conn.Execute = "delete from zhengshu where id="&id
%>
则提示错误是 id丢失