In my case I am displaying about 300 records, i.e. all the records in the
database table.
Bye
Srikanth
-----Original Message-----
From: Singh, Jasbinder [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 11:15 AM
To: [EMAIL PROTECTED]
Subject: Resultset limit
Hi All,
Is there a limit on the number of records that ResultSet can retrieve.
I have a jsp which has a drop-down box. This is populated from a drop
down box. I use a bean to connect to the database and retrieve the values
from the table. The table has close to 2000 entries. But only about 70
values
are getting populated in the drop down box and the page ends there and
doesn't
display the other fields. Is this a problem with the ResultSet or with the
drop-down box.
I wrote a sample java program. It is able to retrieve all the rows from the
table.
Here is a portion of the jsp.
<form>
<%
java.sql.ResultSet rs = null;
try
{
rs=rangeBean.getMembers();
}
catch(java.sql.SQLException e)
{ }
catch(Exception e)
{ }
%>
......
<table width="75%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td>Member Name</td>
<td><select name="Member">
<option selected value="0">Select a member</option>
<%
while(rs.next())
{
out.println("<option
value=\""+rs.getString(1)+"\">"+rs.getString(1)+"</
option>");
}
%>
</select></td>
</tr>
<%.......
...
%>
</table>
...
</form>
</body>
</html>
Could somebody help !
Thanks
JS
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
