Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 14th, 2003, 06:50 AM
Registered User
 
Join Date: Sep 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Splitting a list of asp pages

Hello

Hope I've come to the right place....

I want to be able to display the results of a search, but I want to limit the number of returned results to 10 per page.

Im sure this must be quite easy code to write, but Im fairly new to VBScript and ASP, and would appreciate any pointers in the right direction

Ta very muchly
Mark Taylor

 
Old October 14th, 2003, 07:11 AM
Authorized User
 
Join Date: Sep 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to balakumar1000
Default

Put the logic in your stored procedure so that that will return only that many records to your page.

from stored procedure, you can get how many pages the result will be. This info will be used to display the next and previous links.

send page number and noof records as input parameters to your SP.

Balakumar V.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Having trouble splitting a list to a resultset? Peso SQL Server 2000 4 May 30th, 2006 10:58 AM
asp pages corazon Classic ASP Basics 2 March 7th, 2005 06:16 PM
Passing values between Asp to Asp pages. jayaraj ASP.NET 1.0 and 1.1 Professional 3 May 23rd, 2004 06:53 AM
Varibles between asp.net and Asp Pages koneruvijay VS.NET 2002/2003 1 February 23rd, 2004 04:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.