中科新闻网西安银行面试经验:asp程序问程，请教各位大侠（在线等）
来源：百度文库 编辑：中科新闻网 时间：2024/05/04 22:46:44
<%
sql="select 10"
sql=sql&"download.pic,download.reviewcount,download.note,download.dayhits,download.weekhits,download.lasthits,download.hot,download.size,download.orders,download.id,download.showname,download.dateandtime,download.hits,download.classid,download.Nclassid,DNclass.Nclass "
sql=sql&" from download,DNclass where download.stop=0 and download.Nclassid=DNclass.Nclassid "
sql=sql&" order by download.id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
<%else%>
<%do while not rs.eof%>
<a href="list.asp?id=<%=rs("id")%>"><img src="<%=HostUrl%><%=rs("pic")%>" width="150" height="112" alt="<%=rs("showname")%>" class="paixu"></a>
<%
rs.movenext
loop
end if
rs.close
%>
如果我要把上面的代码改为：在网页中随机显示10张图片的代码，那要怎么改呢？请教请教！
SQL:
<%
sql="select 10"
sql=sql&"download.pic,download.reviewcount,download.note,download.dayhits,download.weekhits,download.lasthits,download.hot,download.size,download.orders,download.id,download.showname,download.dateandtime,download.hits,download.classid,download.Nclassid,DNclass.Nclass "
sql=sql&" from download,DNclass where download.stop=0 and download.Nclassid=DNclass.Nclassid "
sql=sql&" order by newid(),download.id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
<%else%>
<%do while not rs.eof%>
<a href="list.asp?id=<%=rs("id")%>"><img src="<%=HostUrl%><%=rs("pic")%>" width="150" height="112" alt="<%=rs("showname")%>" class="paixu"></a>
<%
rs.movenext
loop
end if
rs.close
%>
ACCESS:
<%
sql="select 10"
sql=sql&"download.pic,download.reviewcount,download.note,download.dayhits,download.weekhits,download.lasthits,download.hot,download.size,download.orders,download.id,download.showname,download.dateandtime,download.hits,download.classid,download.Nclassid,DNclass.Nclass "
sql=sql&" from download,DNclass where download.stop=0 and download.Nclassid=DNclass.Nclassid "
sql=sql&" order by Rnd(download.id) desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
<%else%>
<%do while not rs.eof%>
<a href="list.asp?id=<%=rs("id")%>"><img src="<%=HostUrl%><%=rs("pic")%>" width="150" height="112" alt="<%=rs("showname")%>" class="paixu"></a>
<%
rs.movenext
loop
end if
rs.close
%>