Question

asp代码（如下）如何修改成随机调用。 数据库ACC

<%set rs=server.CreateObject("adodb.recordset")
sql="select top 14 * from admin_news where n_bigclass=3 order by id desc"
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then
do until rs.eof%>
<tr>
<td width="18" height="24" class="xin" ><div align="center">·</div></td>
<td height="24" class="xin"><a href="/news/<%=rs("id")%>.html"><%=left(rs("title"),18)%>
<%if len(rs("title"))>18 then%>
...
<%end if%>
</a></td>
</tr>
<%rs.movenext
loop
end if
rs.close
set rs=nothing%>
sql="select top 14 * from admin_news where n_bigclass=3 order by id desc"

这句是按照降幂排列调用处理。 我想把ACC里的id能随机调用出来。

Answer 1

sql="select top 14 * from admin_news where n_bigclass=3 order by rnd(id) "

Answer 2

你想怎么随机调用, 把需求写清楚啊...

追问

sql="select top 14 * from admin_news where n_bigclass=3 order by id desc"

这句是按照降幂排列调用处理。 我想把ACC里的id能随机调用出来。