Question

asp 报错 ADODB.Recordset 错误 '800a0cb3'

<!--#include file="sql.inc" -->
<%
dim mc,splb,gg,jg,top1,xt,cpjs,zz
id=request.Form("id")
%>
<%

mc=request.Form("mc")
splb=request.Form("splb")
gg=request.Form("gg")
jg=request.Form("jg")
top1=request.Form("top1")
xt=request.Form("xt")
cpjs=request.Form("cpjs")
zz=request.Form("zz")

set rs=server.CreateObject("adodb.recordset")
rs.open "select * from topgg2 where id="&id&"",conn,3,2
rs("mc")=mc
rs("splb")=splb
rs("gg")=gg
rs("jg")=jg
rs("top1")=top1
rs("xt")=xt
rs("cpjs")=cpjs
rs("zz")=zz
rs.update
rs.close
%>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
body {
background-color: #ffffff;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
a {
font-size: 12px;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>

<div align="center">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>已经成功修改数据中数据！</p>
<p><a href="ghzp.asp">返回管理</a></p>
</div>
报错说第19行。大哥门 看下。！

Answer 1

rs.open "select * from topgg2 where id="&id&"",conn,3,2
改为
sql="select * from topgg2 where id='"&id&"'"
rs.open sql,conn,1,3
或者
sql="select * from topgg2 where id="&id&""
rs.open sql,conn,1,3