[thelist] A Little Query Question

[Casey]

Okay - I think my question was not too clear.  I'm doing a paging thing 
where each page only shows 15 results.  Then the user can select to see the 
next 15, then the next, etc.

So, on the initial page load, we can just select the top 15.  No prob. 
Then, if the user wants to see page 2, we need to select items 16 - 30.

I found this with google:   TOP n [ START AT m ]

but I'm not getting it to work.  Hope all this makes sense.  Thanks!

Casey


----- Original Message ----- 
From: "Casey" <aspnet at thecrookstons.com>
To: "The List" <thelist at lists.evolt.org>
Sent: Friday, December 02, 2005 4:13 PM
Subject: [thelist] Fw: A Little Query Question


> If you wanted to return the top 15 rows from a table, you could say 
> "SELECT
> TOP 15 FROM table WHERE..."
>
> How would you word the query if you wanted rows 16 to 30?
>
> (asp.net with MS SQL)
>
> Thanks Tim!!!
>
> Casey
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !