Para limitar el numero de columnas a recibir al ejecutar un query, debes setear el
metodo "setMaxRows", del obj "Statement", el cual devolvera un objeto ResultSet con
el nro de filas especificada...
java.sql.*;
Statemen s= DriverManager.createStatement();
s.setMaxRows(number of rows);
ResultSet rs= s.executeQuery("query String");
"Singh, Jasbinder" wrote:
> 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
