My first guess would be the data itself. I don't think you should have any
problem with displaying that many rows.
Probably the data has some special characters or null values that are ignored by
your drop down and after your javascript
hits this record it bails out. Try displaying the values in a text area instead
, that will tell you whether its a data problem or
some other limitation
Santosh
"Singh, Jasbinder" <[EMAIL PROTECTED]> on 01/17/2001 02:14:49 PM
Please respond to A mailing list about Java Server Pages specification and
reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Santosh Daryani/IT/Aon Consulting)
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
