J
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
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