能不能同时使用conn
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sqll="select top 1 from mybook order by top asc"
sql="select * from mybook"
rs.open sql,conn,3,2
rs1.open sqll,conn,3,2
这样可不可以

set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql1="select top 1 from mybook order by top asc"
sql="select * from mybook"
rs.open sql,conn,3,2
rs1.open sql1,conn,3,2
rs.addnew
rs("top")=rs1("top")+1
rs("name")=name
rs("title")=title
rs("qq")=qq
rs("word")=word
rs("email")=email
rs("face")=face
rs("fpic")=fpic
rs("sex")=sex
rs("time")=now()
rs("face")=face
rs("ip")=request.ServerVariables("REMOTE_ADDR")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write("<script>alert('发表成功');window.location='rword.asp'</script>")
end if
%>
这样出错