猿问

求救!rs.update时出错,BOF 或 EOF 中有一个是“真”?

dim sqlbanjishanchu2,rsbanjishanchu2
Set rsbanjishanchu2 = Server.CreateObject("ADODB.Recordset")
sqlbanjishanchu2="select * from banji where pxid > " & session("yuanpaixutibu")
rsbanjishanchu2.Open sqlbanjishanchu2,conn,3,2

do while not rsbanjishanchu2.eof
rsbanjishanchu2("pxid")=rsbanjishanchu2("pxid")-1
rsbanjishanchu2.movenext
loop
rsbanjishanchu2.update '就是提示这一行出错
rsbanjishanchu2.Close
set rsbanjishanchu2=nothing

response.redirect "?action=banjiguanli"

慕沐林林
浏览 236回答 4
4回答

绝地无双

先说出错原因,因为在数据库游标指针到最后一行的时候,又来了一次movenext,所以此时的游标指针就指到空地方放了,所以报错。再说解决办法,既然你说数据库都修改过来了说明update已经将游标指针所经过的数据都修改过了,当然也包括那个所谓的【真】,可是修改到【真】这地方出错了,那么解决办法来了,就是不让update对【真】生效即可。因此,我们之需要在update之前加入个moveprevious即可,代码如下:rsbanjishanchu2.movepreviousrsbanjishanchu2.update

慕哥6287543

do while not rsbanjishanchu2.eofrsbanjishanchu2("pxid")=rsbanjishanchu2("pxid")-1rsbanjishanchu2.movenextlooprsbanjishanchu2.updatersbanjishanchu2.Closeset rsbanjishanchu2=nothing改为do while not rsbanjishanchu2.eofrsbanjishanchu2("pxid")=rsbanjishanchu2("pxid")-1rsbanjishanchu2.updatersbanjishanchu2.movenextlooprsbanjishanchu2.Closeset rsbanjishanchu2=nothing

素胚勾勒不出你

rsbanjishanchu2.Open sqlbanjishanchu2,conn,3,2改为rsbanjishanchu2.Open sqlbanjishanchu2,conn,3,3试试

墨色风雨

用户输入界面user.php若下:<body><form name="form" action="matlab.php" method="post"><table border="0" cellpadding="0" cellspacing="0"><tr height="30"><td width="40%" align="right">输入信息:</td><td align="left" ><input name="shuju" type="text" class="input"/></td></tr></table></form></body>在matlab.php中<?php$shuju=$_POST['shuju'];echo $shuju;?>这是php语言做的,不知道对你有不有用
随时随地看视频慕课网APP
我要回答