Classic ASP Discussion - Randomising a recordset can anyone help?

Print Page | Close Window

Randomising a recordset can anyone help?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=308
Printed Date: 29 March 2026 at 2:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Randomising a recordset can anyone help?

Posted By: theGuide
Subject: Randomising a recordset can anyone help?
Date Posted: 19 February 2003 at 9:06am

Sorry this is a bit lazy but I just don't have time to find out how at the moment!! Setting up a site using a connection to an Access 2000 db. I have a recordset sorted by ID number at the moment the SQL being

SELECT *
FROM biztype
ORDER BY ID ASC

Anyone know what I can do to randomise the table order?

Grateful thanks

mailto: andy.cooke@getawaydigital.com - mailto: andy.cooke@getawaydigital.com

Replies:

Posted By: michael
Date Posted: 19 February 2003 at 9:18am

this is just one example: http://www.4guysfromrolla.com/webtech/102999-1.shtml - http://www.4guysfromrolla.com/webtech/102999-1.shtml

Posted By: Bunce
Date Posted: 20 February 2003 at 10:26pm

This would work in SQL Server:

SELECT *
FROM biztype
ORDER BY NewID()

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.