蓬荜增辉的意思是什么:asp 缺少对象: '' ??

来源:百度文库 编辑:高考问答 时间:2024/04/29 21:54:56
<%
'delect_id=Request("delect_id")
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("../data.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath

sql="delete from work where id="&request.QueryString("delect_id")
rs.open sql,conn,1,3
conn.close
set conn=nothing
%>

</body>
</html>

我想按提交过来的ID号删除相应的内容.要怎样改呢?
现在这样就说:rs.open sql,conn,1,3这行缺少对象: ''

sql="delete from work where id="&request.QueryString("delect_id")
修改:
sql="delete * from work where id="& request.QueryString("delect_id") &""

<%
'delect_id=Request("delect_id")
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("../data.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
set rs=Server.CREATEOBJECT("ADODB.recordset")
sql="delete from work where id="&request.QueryString("delect_id")
rs.open sql,dbconnection,1,3
dbconnection.close
set dbconnection=nothing
%>

<%
'delect_id=Request("delect_id")
set conn=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("../data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
set rs=Server.CREATEOBJECT("ADODB.recordset")
sql="delete from work where id="&request.QueryString("delect_id")
rs.open sql,conn,1,3
conn.close
set conn=nothing
%>

rs有没有定义过?
conn是否应该是dbconnection?