Want to show Records on ASP Page randomly

pkdev · July 27th, 2003, 12:34 AM

AOA All,

I m a regular user of this forum and it realy help me very much in my professional life.i m having a problem and i hope some one ll realy help me in this problem.
Actually i m working on an online store and according to client requirement i want to display some of the products on main page and requirement is to display the products randomly.when some one visit the website he view different products every time.i m using ASP 3 and SQL Server 2000.
A real time example/Code will be appreciated.
Thanks

PKDEV

vinyl-junkie · July 27th, 2003, 12:25 PM

How about loading the products into an array via the GetRows method, then calling a random number generator to pick which row (i.e., product) to display? As for generating that random number, here is some sample code for that:
http://www.asp101.com/samples/random_number.asp

Hope this helps. :)

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

uit · July 27th, 2003, 02:59 PM

I just had this need myself, and this site helped me - this page in particular:

http://www.mssqlserver.com/faq/devel...randomrows.asp

Hope it can help you as well..

Quote:

quote:Originally posted by pkdev
AOA All,

I m a regular user of this forum and it realy help me very much in my professional life.i m having a problem and i hope some one ll realy help me in this problem.
Actually i m working on an online store and according to client requirement i want to display some of the products on main page and requirement is to display the products randomly.when some one visit the website he view different products every time.i m using ASP 3 and SQL Server 2000.
A real time example/Code will be appreciated.
Thanks

PKDEV

pgtips · July 28th, 2003, 03:20 AM

This method is much simpler (from http://www.adopenstatic.com/FAQ/randomrecord.asp)

Code:

SELECT
   TOP 1 CategoryID,
   CategoryName FROM
   Categories
ORDER BY
   NewID()