上一篇
下一篇
asp中ACCESS数据库抽取随机记录
作者:winxml 日期:2009-09-29
程序代码 Randomize()
intRandomNumber = Int(1000 * Rnd) + 1
orDER BY Rnd("& (-1 * intRandomNumber) &"* id)
intRandomNumber = Int(1000 * Rnd) + 1
orDER BY Rnd("& (-1 * intRandomNumber) &"* id)
使用示例:
程序代码Dim RsP1, SQLP1, intRandomNumber
Randomize()
intRandomNumber = Int(1000 * Rnd) + 1
SQLP1="select top 4 * from Lonely_Article where ChannelID=1 and ClassID="&rs("ClassID")&" and ArticleID <> "&ArticleID&" orDER BY Rnd("& (-1 * intRandomNumber) &"* ArticleID)"
Randomize()
intRandomNumber = Int(1000 * Rnd) + 1
SQLP1="select top 4 * from Lonely_Article where ChannelID=1 and ClassID="&rs("ClassID")&" and ArticleID <> "&ArticleID&" orDER BY Rnd("& (-1 * intRandomNumber) &"* ArticleID)"
文章来自: 
引用通告: 
Tags: 评论: 0 | 引用: 0 | 查看次数: -
发表评论
