随机调用n条数据的方法分析

step一:sql="selectidfromtable"结果用存在rs=conn.execute(sql)

step二:生成一个step1的最大值(rs.recordcount)内的随机数字.N个

code:

<%Randomize%>

<%

dimr(10)

fori=0toUBound(r)

r(i)=int(Rnd()*100)

int(Rnd()*100)

%>

step三:将数组联合join成一个","分割的

<%Randomize%>

<%

sql="selectidfromtable"

rs=conn.execute(sql)

maxrecord=rs.recordcount

dimr(10)

fori=0toubound(r)

r(i)=rs(int(rnd()*maxrecord))

next

s=join(r,",")

sql="select*fromtablewhereidin("&s&")"

newrs=conn.execute(sql)

%>