ASP & SQL - <Next N> results

ASP & SQL - <Next N> results

Post by Suresh Pera » Tue, 16 Nov 1999 04:00:00

When there is more data in a query's result set than
can be displayed to the user, normally we display the
first N rows and give an option to get more. What is
the best way to handle this <get next N items> functionality?

I see three ways of doing it:

1. When the user asks for the <next N> , do the full
    query again and pick the appropriate N items

2. Store all the results in Session variables (i.e. in Memory)

3. Store the results in temporary tables. (to avoid a full query,
    but still accessing the database)

What do people do generally?




1. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

YOH Information Technology has several long-term contract positions
with one of our Houston clients.   This company is working on a large,
complex and important government contract developing Oracle databases
for scientific data.  This is a fulfilling place to work where your
peers will be world class scientists, engineers and programmers.

Need several PL/SQL Designers.  You must have experience writing
complex stored procedures or triggers in PL/SQL;  additionally, you
should have experience with Oracle Tools (Designer/Developer 2000) and
at least familiarity with SQL*Loader and Unix;   If you have done Unix
scripting (or Perl), VB and/or Java design on a Web interface, that's
a plus!   Call us to discuss this great opportunity!  No obligation on
your part, your information will be handled with discretion and you'll
gain a friend in the business!  

Fax your resume (which will be held in strict confidence) to Shannon
Lucente at  713-524-2232 (or call 1-888-397-1341) or e:mail to


Our clients require a minimum of one year of non-academic, commercial
experience, unless otherwise noted.  If you are a recent grad, we will
maintain your resume for future contacts;  after you have one year of
commercial experience, we would be happy to support your career

All resumes will be held in strict confidence.  We will not contact a
client on your behalf until you have given us permission to do so.

YOH Information Technology is a division of the H.L. Yoh Company, the
oldest technical contract staffing firm in the country.  With over 50
years experience in the contract placement industry, we have more than
45 offices across the country to serve you.

In Houston, our staff has a total of more than 50 years of successful
experience in technical staffing.  You will find us to be knowledgable
about what you do, in touch with the technical labor market (both
contract and permanent) in Houston and we will treat you with respect.
See further information on our Web Page at

2. ADO Data Type Query

3. Oracle / MS SQLServer - string concatenation & other migration issues

4. Q] How can I access the mdb file in Java script?

5. Pc Magic 3.00b & conversion to DDF