4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 randomize an entire recordset?
Post New TopicReply to Topic Forum Index » Databases
View Previous Topic Print this topic View Next Topic
Author Message
lozhowlett
Junior WebHelper
Junior WebHelper


Joined: 17 Mar 2004
Posts: 1
PostPosted: Wed Mar 17, 2004 3:50 pm (20 years, 1 month ago) Reply with QuoteBack to Top
Hi there

I am currently building a villa holiday web site, where owners of villas can pay to display a villa advert.

However on the search page I wish to randomise the results, and still show only 10 per page, with page moves. i.e. next 10, last 10, first 10, etc.

I have no idea how to go about this, I am using ASP, MS Access. So i cant use the SQL 7 statesment order by NEWID().

Any help much thanks, Smile
OfflineView User's ProfileFind all posts by lozhowlettSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic Forum Index » Databases
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.20299 seconds :: 19 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme