做幻灯片,数据库连接正常,但出现"至少一个参数没有被指定值"问题,急死俺啦...帮...帮...俺吧!
做幻灯片,数据库连接正常,但出现"至少一个参数没有被指定值"问题,恳请各位老师的帮助,谢谢!代码如下:
<%
set rs = server.CreateObject ("adodb.recordset")
sql = "select top 5 * from news where lm<>'13' and pic<>''order by id desc"
rs.open sql,conn,1,1..............................错误类型：Microsoft JET Database Engine (0x80040E10)至少一个参数没有被指定值。/hdp2/index.asp, 第 8 行
pic1=rs("pic")
link1=rs("url")
text1=rs("title")
rs.movenext
pic2=rs("pic")
link2=rs("url")
text2=rs("title")
rs.movenext
pic3=rs("pic")
link3=rs("url")
text3=rs("title")
rs.movenext
pic4=rs("pic")
link4=rs("url")
text4=rs("title")
rs.movenext
pic5=rs("pic")
link5=rs("url")
text5=rs("title")
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<body>
<a target=_self href="javascript:goUrl()"> <span class="f14b">
<script type="text/javascript">
imgUrl1="<%=pic1%>";
imgtext1="<%=text1%>"
imgLink1=escape("<%=url1%>");
imgUrl2="<%=pic2%>";
imgtext2="<%=text2%>"
imgLink2=escape("<%=url2%>");
imgUrl3="<%=pic3%>";
imgtext3="<%=text3%>"
imgLink3=escape("<%=url3%>");
imgUrl4="<%=pic4%>";
imgtext4="<%=text4%>"
imgLink4=escape("<%=url4%>");
imgUrl5="<%=pic5%>";
imgtext5="<%=text5%>"
imgLink5=escape("<%=url5%>");
var focus_width=180
var focus_height=150
var text_height=15
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.,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="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="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. />'); document.write('</object>');
</script>
</span>
[ 本帖最后由 tepnidh 于 2010-2-5 13:42 编辑 ]
hdp.rar