response.Write返回指定页问题
<!--#include file="conn.asp"-->
<%
dim sql
sql="select * from books where bookid="&request.querystring("bookid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs("huiyuanjia")=request.form("huiyuanjia")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.Write "<script language=javascript>alert('修改成功！');window.location.reload('shopping.asp?id="&rs("bookid")&"')</script>"
%>
当执行上面这代码时，想直接返回标着红色的这个页面，好像写错了。好色的这个应该怎么改。谢谢。
[解决办法]
红色标注的语法没错的.错在你先把结果集关闭了，你在response.write中的rs("bookid")当然访问不到了
可以先把rs("bookid")赋给一个变量
<%
dim sql
dim strID:strID=0
sql="select * from books where bookid="&request.querystring("bookid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs("huiyuanjia")=request.form("huiyuanjia")
rs.update
strID=rs("bookid")
rs.close
set rs=nothing
conn.close
set conn=nothing
response.Write "<script language=javascript>alert('修改成功！');window.location.reload('shopping.asp?id="&strID&"')</script>"
%>
