原代码如下,关键是红色部分,按下面的语句没有错误,但多加一个判断就无法正常显示,下面查询按picname(图片字段)不为空,如果再加上类别:sql = "select * from news where picname<>'' and bigclassid=81 order by newsid desc"就不行了,不知什么原因呀????????????


<A
href="javascript:goUrl()" target=_self>
<%
set rssou=server.createobject("adodb.recordset")
sql = "select * from news where picname<>'' order by newsid desc"
rssou.open sql,conn,1,3%>
<SCRIPT type=text/javascript>
<%a=1
do while not rssou.eof%>
imgUrl<%=a%>="spread/<%=rssou("picname")%>";
imgtext<%=a%>="<%=rssou("title")%>";
imgLink<%=a%>=escape("newsshow.asp?newsid=<%=rssou("newsid")%>");
<%a = a + 1
if a>5 then
exit do
end if
rssou.movenext
loop
rssou.close%>
var focus_width=200
var focus_height=150
var text_height=20
var swf_height = focus_height+text_height

var pics=imgUrl1+"|"+imgUrl2+"|"+imgUrl3+"|"+imgUrl4+"|"+imgUrl5
var links=imgLink1+"|"+imgLink2+"|"+imgLink3+"|"+imgLink4+"|"+imgLink5
var texts=imgtext1+"|"+imgtext2+"|"+imgtext3+"|"+imgtext4+"|"+imgtext5

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="images/focus.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="images/pixviewer.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="'+ focus_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />'); document.write('</object>');
</SCRIPT>
</A>

不为空,应该是用""吧?

sql = "select * from news where picname<>"" and bigclassid=81 order by newsid desc"

不是吧,我在查询语句里不为空都用''的,试试看!!

连数据都读不出来了!!!!!!!!!!!!!

只要加bigclassid=81就出错:
行: 308

字符: 16

错误: 缺少 ';'

代码: 0

URL: http://127.0.0.1/web/龙湾II/web/index.asp

单独查询它也不行,但不用在图显示这个地方在加的地方直接输出是没问题的!!

我看你的 <SCRIPT type=text/javascript>下面有很大的问题