But you shouldn't have to do a QofQ you should jsut be able to use
your current code. If you want to change your SQL as far as I know the
only way to do this is something like this:
SELECT Top 100 Partnumber From Products
WHERE Product_ID Not In
(SELECT Top 199 Product_ID FROM Products c ORDER BY Partnumber)
ORDER BY Partnumber
So basically that is select the second page....
Adam H
On Thu, 29 Jul 2004 13:26:05 +0200, Hugo Ahlenius
<[EMAIL PROTECTED]> wrote:
> I think you can do it in sql, but I'm no wizard there -- I am sure there
> is one of the SQL Aces that can answer you there.
>
> But what you can do -- store the result query in the session scope, then
> you can QoQ it to get the results that you want, without having to go to
> the database. By the way -- 5000 records sounds like way too much (are
> 50+ pages with 100 hits each really needed to locate the piece of
> information that you are looking for).
>
> --
> Hugo Ahlenius
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
