圣诞快乐！！怎样随机从库中取指定数目记录？谢谢！

[iStringTheory]

谢谢！

[iStringTheory]

u p

[netcar]

说清楚点...

[nowokcom]

Function gen_key(digits)
dim char_array(50)
char_array(0) = "0"
char_array(1) ="1"
char_array(2) ="2"
char_array(3) ="3"
char_array(4) ="4"
char_array(5) ="5"
char_array(6) ="6"
char_array(7) ="7"
char_array(8) ="8"
char_array(9) ="9"

Randomize

While len(output) < digits
num = char_array(Int(35 * Rnd + 0))
output = output + num
Wend

gen_key = output
End Function
RandomID=gen_key(2)

Select * From tablename where id='"&RandomID&"'

[iStringTheory]

怎样随机取出多条记录？

[iStringTheory]

没高手吗？

[haiznan]

nowokcom(蚊子蜂)　

算你狠~~~例子经典~~

[xiaoxiaohan]

圣诞快乐！！