ASP: Query Access db

  • Johan007
  • Guru
  • Guru
  • User avatar
  • Posts: 1080
  • Loc: Aldershot, UK

Post 3+ Months Ago

What I want to do is pull up a random recommended movie with a high rating from the db to pull onto the front page of my http://www.futuremovies.co.uk . So the SQL is something like this:

SELECT Top *, Review.ID AS [reviewID] FROM Review
WHERE Review.Rating > 7
ORDER BY Random Review ID :shock:

There must be a way of doing this in SQL but I can not find it so I guess I am barking up the wrong tree. What would any of you do?

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 108 guests
  • 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 post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.