Re: TOP and OFFSET

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)
  • 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)
  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)