I am new to ASP and I want to display only 5 records for my moviesite...
SELECT Top 5 *, Article.ID AS [ArticleID] FROM Article"
WHERE Article.delete<>'Y' ORDER BY Priority
But if the Priority is the same value as another record then it will show 6 and so mucks up my right columb of my homepage...
<!-- w --><a class="postlink" href="http://www.futuremovies.co.uk/moviesite/Oh">www.futuremovies.co.uk/moviesite/Oh</a><!-- w --> blarg all I have to do is a simple loop!
for i = 1 to 5
next
SELECT Top 5 *, Article.ID AS [ArticleID] FROM Article"
WHERE Article.delete<>'Y' ORDER BY Priority
But if the Priority is the same value as another record then it will show 6 and so mucks up my right columb of my homepage...
<!-- w --><a class="postlink" href="http://www.futuremovies.co.uk/moviesite/Oh">www.futuremovies.co.uk/moviesite/Oh</a><!-- w --> blarg all I have to do is a simple loop!
for i = 1 to 5
next