Question

ASP问题 缺少对象

conn文件内容

<%
Dim conn,rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/database/8651opw%!.mdb")
Set rs = Server.CreateObject( "ADODB.Recordset" )
%>

save.asp文件内容
<!--#include file="conn.asp"-->

<%
dim name,price,company,amount,photo,feild,time,intro,vippri
name=request.form("name")
company=request.form("company")
time=request.form("time")
price=request.form("price")
vippri=request.form("vip_price")
amount=request.form("amount")
ptoto=request.form("photo")
feild=request.form("feild")
intro=request.form("intro")

judge=request.form("feild")
sql="select * from feild "
set rs=conn.execute(sql)

while not rs.eof
if judge=rs("feild") then
temp=rs("name")
end if
rs.movenext
wend
rs.close
set rs=nothing

sql="select * from '"&temp&"'"

rs.open sql,conn,1,3

rs.addnew
rs("name")=name
rs("company")=company
rs("time")=time
rs("price")=price
rs("vip_price")=vip_price
rs("amount")=amount
rs("photo")=photo
rs("feild")=feild
rs("intro")=intro

rs.update
rs.close
set rs=nothing

%>
提示在save文件的31行错误，为什么呢？各位高手能帮我解决不阿？

Answer 1

你在上面都把做了：
rs.close
set rs=nothing
当然会报错了

你得在 rs.open sql,conn,1,3 再加句这
Set rs = Server.CreateObject( "ADODB.Recordset" )

Answer 2

31行是什么？？