Hey!
Let me start of by saying this is off-topic for SERVLET-
INTEREST, but I hope that a short response will keep
others from responding to this post.
For the HTML response, I suggest that when you get
your ResultSet from the db that you create a Vetctor of objects
that holds the data of concern. These objects could be another
vector, therefore you have a Vector of Vectors. Or the objects
could be Java beans with getters and setters (JSPbean),
which is much more flexible. Then in your
servlet you can keep track of your 'index' into the data and
control your output response to the client browser.
I cain't comment on Microsoft SQLServer. I try not use it.
The experience I had with it was problematic. It has strange
datatypes that no other database uses. I think MS wants
to support Access datatypes. Now there's a product that
should have been killed long ago.
Sans adieu,
Danny Rubis
"Liu, Leo Huaizhen" wrote:
> Stored_procedure gurus,
>
> I want to create stored_procedure in SQL Server with following parameters:
>
> start_num:
> start point of recordset, i.e. start_num=40 means, only retrieve records
> from 40 in the record list
> end_num:
> end point of recordset, i.e. end_num=60 means, only retrieve record to
> 60th.
> GPA:
> search criteria, i.e. GPA > 4.0
>
> The query is something like this:
>
> SELECT * FROM tblStudents
> WHERE tblStudents.GPA > 4.0
>
> If the query returns 10,000 records, that is too much for JSP/Servlet to
> handle,
> however, if each time it only return records between start_num to end_num
> that will
> be good.
>
> Any solution, hint and sample code will be appreciated.
>
> Thanks,
>
> Leo
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
