|
Home > Archive > MS SQL Server MSEQ > May 2005 > TOP and OFFSET
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Garfinkle 2005-04-29, 7:25 am |
| I'm trying to create a JSP page which access's a database of about 3 million
records. What i am trying to do is display this in a webpage table with 15
results per page. I can get a display of 15 records but the only start from
the first row in the table. I have found out that offset does not work in
MSQL2000 and im wondering is there a way that you can specify where to starrt
dispalying from.
Any help would be extremely appreciated
Garfinkle
| |
| Hugo Kornelis 2005-05-09, 8:24 pm |
| On Fri, 29 Apr 2005 04:48:04 -0700, Garfinkle wrote:
>I'm trying to create a JSP page which access's a database of about 3 million
>records. What i am trying to do is display this in a webpage table with 15
>results per page. I can get a display of 15 records but the only start from
>the first row in the table. I have found out that offset does not work in
>MSQL2000 and im wondering is there a way that you can specify where to starrt
>dispalying from.
>
>Any help would be extremely appreciated
>
>Garfinkle
Hi Garfinkle,
Check out the paging techniques described at
http://www.aspfaq.com/show.asp?id=2120
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
| |
| Garfinkle 2005-05-10, 3:24 am |
| Thank you very much hugo. That page was excellent.
"Hugo Kornelis" wrote:
> On Fri, 29 Apr 2005 04:48:04 -0700, Garfinkle wrote:
>
>
> Hi Garfinkle,
>
> Check out the paging techniques described at
> http://www.aspfaq.com/show.asp?id=2120
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>
|
|
|
|
|