asp 随机选择一条数据
set rs=server.createobject("adodb.recordset")
sql="select * from message order by id"
rs.open sql,conn,1,3
upperbound = rs.recordcount
Randomize
Qno = Int((upperbound - 2) * Rnd + 1)
rs.move(Qno)
sql="select * from message order by id"
rs.open sql,conn,1,3
upperbound = rs.recordcount
Randomize
Qno = Int((upperbound - 2) * Rnd + 1)
rs.move(Qno)
posted on 2009-09-16 11:31 Master zhu 阅读(193) 评论(0) 编辑 收藏 举报