Re: TOP and OFFSET

Thank you very much hugo. That page was excellent.

"Hugo Kornelis" wrote:

> 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)
>
.

Relevant Pages

  • Re: onclick of row of table the value should be in textbox in jsp
    ... row should be displayed in the textbox on second page in jsp. ... The table consists of records from database. ... and then display in table? ...
    (comp.lang.java.programmer)
  • Re: save result to text file in JSP
    ... > I have a JavaServer Page which get data from database then display it for user ... Since you just said that you've tied your database access to the JSP, ...
    (comp.lang.java.programmer)
  • Re: TOP and OFFSET
    ... >I'm trying to create a JSP page which access's a database of about 3 million ... What i am trying to do is display this in a webpage table with 15 ... Hi Garfinkle, ...
    (microsoft.public.sqlserver.mseq)
  • communication between JSP and Servlet
    ... in one jsp page i have to connect to the database and retrieve ... information and display that on the same jsp page but the layout will ...
    (comp.lang.java.programmer)
  • TOP and OFFSET
    ... I'm trying to create a JSP page which access's a database of about 3 million ... What i am trying to do is display this in a webpage table with 15 ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)