an idea
you have to know all the time exactly where you are in result set
( start, end | step)
run query, skip first first rows -
do what you want with next "step" rows [ for ( int i = start; i <
start + step; i ++) ...]
close result set
create a template with parameters for this page ...
( it works on any db)
br,
dan
hope this help
At 12:57 PM 6/15/2001 -0400, you wrote:
>This may be a little off topic, please forgive me. One of my webapplications
>displays a group of results from a database query. These can be hundreds of
>rows long. I would like to break these up into smaller sections to fit on a
>page.
>
>My problem is, I don't want to run the entire query at once and save it to
>memory.
>
>PostgreSQL and MySQL have the LIMIT num,offset qualifier which does exactly
>what I want. The problem is that I'm using MS SQL and it doesn't use the
>LIMIT keyword. Instead, it uses TOP and you can't supply an offset.
>
>My quetion: Is there anyway to specify an offset into a query using MS SQL
>Server? Thank you.
>
>--min
