Question

ADODB.Recordset '800a0bcd'BOF 或 EOF 中有一个是“真”

ADODB.Recordset '800a0bcd'BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
\wwwroot\play.asp, line 4
___________________________________

下面是play.asp代码:

<%
set rsplay=server.CreateObject("adodb.recordset")
rsplay.open "select * from paperbig where pic<>'' and bigname='实时资讯' and movetop<>'1' order by pictop desc,top desc,datetime desc",conn,3,2
rsplay.movefirst
pic1=rsplay("pic")
link1="News_show.asp?id="&rsplay("id")&""
title1=left(rsplay("title"),18)

rsplay.movefirst
rsplay.move 1
pic2=rsplay("pic")
link2="News_show.asp?id="&rsplay("id")&""
title2=left(rsplay("title"),18)

rsplay.movefirst
rsplay.move 2
pic3=rsplay("pic")
link3="News_show.asp?id="&rsplay("id")&""
title3=left(rsplay("title"),18)

rsplay.movefirst
rsplay.move 3
pic4=rsplay("pic")
link4="News_show.asp?id="&rsplay("id")&""
title4=left(rsplay("title"),18)

rsplay.movefirst
rsplay.move 4
pic5=rsplay("pic")
link5="News_show.asp?id="&rsplay("id")&""
title5=left(rsplay("title"),18)
rsplay.close
set rsplay=nothing
%>
<SCRIPT type=text/javascript>
<!--

var focus_width=280
var focus_height=210
var text_height=20
var swf_height = focus_height+text_height

var pics='<%=pic1%>|<%=pic2%>|<%=pic3%>|<%=pic4%>|<%=pic5%>'
var links='<%=link1%>|<%=link2%>|<%=link3%>|<%=link4%>|<%=link5%>'
var texts='<%=title1%>|<%=title2%>|<%=title3%>|<%=title4%>|<%=title5%>|'

document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="flash01.swf"><param name="quality" value="high"><param name="bgcolor" value="#F0F0F0">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
document.write('<embed src="flash01.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#F0F0F0" quality="high" width="'+ focus_width +'" height="'+ swf_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');
document.write('</object>');

//-->
</SCRIPT>

Answer 1

你就读出四条记录，用不着这么麻烦啦
rsplay.open "select top 5 * from paperbig where pic<>'' and bigname='实时资讯' and movetop<>'1' order by pictop desc,top desc,datetime desc",conn,1,1
然后就循环读出就是了，循环里面直接加“|”，然后再把最后那一个“|”去掉就是了。

ADODB.Recordset '800a0bcd'BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
这个错误是指你用的某个语句，找不到记录