Forums

ASP

This topic is locked

Listing recordset values in random order?

Posted 02 Jun 2003 17:00:34
1
has voted
02 Jun 2003 17:00:34 Bec C posted:
How do I list recordset entries in a random order? For example I want to list business names on a random basis so the top 10 are different each time a viewer comes to the page.

Thanks

Replies

Replied 03 Jun 2003 01:44:59
03 Jun 2003 01:44:59 Phil Shevlin replied:
I suggest you just move to a random record then display then next 9 rows:

www.dmxzone.com/showDetail.asp?TypeId=3&NewsId=3705
Replied 16 Dec 2003 23:39:50
16 Dec 2003 23:39:50 Pablo SanJuan replied:
There is a problem with that, because when the random record hit the last record you only see 1 record instead of 10
Any solve to tha problem?

Replied 17 Dec 2003 01:41:48
17 Dec 2003 01:41:48 Phil Shevlin replied:

Reply to this topic