ASP Paging with Stored Procedure

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi all,

I am wanting to implement paging with asp & sql server 2000.
In mysql i would simply issue a 'Limit clause such as Limit 10,1'.

In sql server i know you use SET ROWCOUNT to specify the number of rows to
be returned. My difficulty is how do i get the starting row for my paging.

In simple terms i want to retrieve 'n' number of rows after record as
position 'i'.

How can i do this?

I have read through asp faq, and it has helped but still fuzzy on this
particular item.
I am prefering not to retrieve all records in a table and use ado to filter
them for performance reasons.

Help appreciated!!
.

Relevant Pages

  • Re: ASP Paging with Stored Procedure
    ... > I am wanting to implement paging with asp & sql server 2000. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Connection.Execute and SQL stored procedures
    ... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Heres a rather broad question...
    ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ... IIS user doesn't have the proper permissions to access the database, ...
    (microsoft.public.data.ado)
  • Re: WAP, ASP engineer required - London
    ... > at the company I work for we need to hire in London a WAP ASP engineer ... > You should have experience of SQL Server database design and as ... online service development the ideal ... > candidate will be technically minded and have experience in SQL Server ...
    (microsoft.public.inetserver.asp.general)
  • Re: Need some fresh ideas
    ... I have an upload form that allows a user to browse and select ... asp server script validates the input ... SQL Server to it ... * editFile updates the form data. ...
    (comp.lang.javascript)