Analysis of method of randomly calling n pieces of data

step 1:sql="selectidfromtable" result with rs=conn.execute(sql)

Step 2: Generate a random number within the maximum value of step1 (rs.recordcount) .N

code:

<%Randomize%>

<%

dimr(10)

fori=0toUBound(r)

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

int(Rnd()*100)

%>

Step 3: Join the array into a "," split

<%Randomize%>

<%

sql="selectidfromtable"

rs=conn.execute(sql)

maxrecord=rs.recordcount

dimr(10)

fori=0toubund(r)

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

next

s=join(r,",")

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

newrs=conn.execute(sql)

%>