Shuffling / Random

[John]

Hi, i have a db where ± 15 users stores multiple second hand items with
images.
Now i wish to display on the openingpage a list of all users with 1 item +
image. So far no problem.

But now i wish to change the order of the users every time the pages open.

How can i shuffle the recordset before i load the users in a array, or how
can i shuffle the array after populating with the users?
Thx - John.

x=1
RS.open "SELECT DISTINCT * FROM tblUsers"
Do While Not RS.Eof
users(x) = RS("usr_vat"):x=x+1
RS.MoveNext
Loop
RS.Close

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2132

--
http://www.aspfaq.com/
(Reverse address to reply.)


"John" <n o b o d [e-mail]> wrote in message
news:s1***********************@phobos.telenet-ops.be...

Hi, i have a db where ± 15 users stores multiple second hand items with
images.
Now i wish to display on the openingpage a list of all users with 1 item +
image. So far no problem.

But now i wish to change the order of the users every time the pages open.

How can i shuffle the recordset before i load the users in a array, or how
can i shuffle the array after populating with the users?
Thx - John.

x=1
RS.open "SELECT DISTINCT * FROM tblUsers"
Do While Not RS.Eof
users(x) = RS("usr_vat"):x=x+1
RS.MoveNext
Loop
RS.Close