Classic ASP Discussion - Limiting number of requests on page

Print Page | Close Window

Limiting number of requests on page

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=11584
Printed Date: 31 March 2026 at 4:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Limiting number of requests on page

Posted By: wolfie
Subject: Limiting number of requests on page
Date Posted: 20 August 2004 at 2:56pm

I have a Blog scirpt coded, but at the moment, all it does is grabs information from the Database and show all of the records. Now I want it to show a certain number, say 5. How do I go about coding this?

-------------
Wolfie--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[

Replies:

Posted By: Mart
Date Posted: 20 August 2004 at 3:14pm

If you want it on pages so you can navigate through, have a look on google http://www.google.com/search?sourceid=navclient&ie=UTF-8&q=Paging+in+ASP - http://www.google.com/search?sourceid=navclient&ie=UTF-8 &q=Paging+in+ASP

If you simply want to show the first five records, no pages then just change your query from 'SELECT x FROM x' to 'SELECT TOP 5 x FROM x'