🚀 go-pugleaf

One possibility is to create a table on the server to hold the results.
This table should have columns for all of the columns that you want to
return as well as an incrementing column (NOT an identity column -
you'll need to get this value yourself since it needs to start at 1 for
each user and increment without skipping numbers), a datetime column
that defaults to the time that a record is added and a column (or
multiple columns if necessary) to identify the user or connection that
made the search request.

When a user makes a search request you insert the results into this
table and return them from there. You can use the incrementing column
to limit which records you are showing. You just need to make sure that
the table gets cleaned up every once in awhile as results "timeout".

This is something that I just came up with off the top of my head, so
there may be a much better way to do it. It seems like MTS would be
able to handle something like this, but I don't know what its
capabilities are. Maybe someone else has a better solution?

   Good luck,
      -Tom.

In article <39E82003.E697B472@oernii.sk>,
  Ernest 'OERNii' Beinrohr <oernii@oernii.sk> wrote:
> Hi there, is there a possibility in MS SQL server 7 to limit the
output
> from a select query per LINES ?????? (not where)
> Like:
>
> select * from table limit 1000,1100
> 		(this should get me only the lines 1000 - 1100)
>
> I need this to make "pages" on my www search results.
>
> Thanx for help.
> PS: sorry for crossposting
> --
>
==========================----------------------------------------------
---
> OERNii - Ernest Beinrohr |  @@@@@@   @@@@@@@@  @@@@@@@   @@@  @@@
@@@  @@@
> mailto:oernii@oernii.sk  | @@!  @@@  @@!       @@!  @@@  @@!@!@@@
@@@  @@@
> http://www.oernii.sk     | !@!  !!!  !!!!!:    !!@!@!    !@!  !!!
!!!  !!!
> #holubnik on IRCNET      | :!:  !:!  :!:       :!:  !:!  :!:  !:!
:!:  :!:
> ICQ No : 28153343        |  : :  :   : :: ::    :   : :  ::    :
:    :
>


Sent via Deja.com http://www.deja.com/
Before you buy.