|
| |
|
|
barking mad
Posts: 287
Joined: 12/6/2002
From: Out in the sticks, UK
Status: offline
 |
sorting database results - 4/27/2009 7:03:13
I have an access database which when queried (using ASP coding) returns back a list of members
I want to be able to display that list in a random order evry time. So if you returned the same list of members again they would display in a different order.
I know how to a-z both asc and desc, I've seen rnd and rand used but neither seem to work with access.
Any ideas would be appreciated. Thanks.
_____________________________
The more I ask, the more I learn, the more I' m confused, therefore the more I ask ...
|
|
|
|
barking mad
Posts: 287
Joined: 12/6/2002
From: Out in the sticks, UK
Status: offline
|
RE: sorting database results - 4/27/2009 10:28:02
thanks for that but the results set that is initially returned is to be the same every time, see pm.
_____________________________
The more I ask, the more I learn, the more I' m confused, therefore the more I ask ...
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
