shd be choose[n] instead of choose[i] ----- Original Message ----- From: "Adrian Janssen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 1:56 PM Subject: Re: hi pblm in JSP form
> </option> missing > > > -----Original Message----- > > From: arun s [SMTP:[EMAIL PROTECTED]] > > Sent: 06 January 2003 04:30 > > To: [EMAIL PROTECTED] > > Subject: hi pblm in JSP form > > > > hi all, > > I hav a pblm in HTML + JSP form. I want to generate a pulldown menu > > based > > on a Database values dyanmically. Im able to retrive and set the values to > > a > > array. But Im unable to put it in a pulldown menu where it displays null > > instead of that value. Im able to understand the pblm y its so but I dont > > know how to solve it. Can some one just recode my coding so that I get a > > correct output at pulldown menu. > > > > > > > > <%@page session="true"%> > > <%@page import="javax.servlet.*"%> > > <%@page import="javax.servlet.http.*"%> > > <%@page import="java.io.*"%> > > <%@page import="java.sql.*"%> > > <%@page import="java.lang.*"%> > > > > <% > > Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); > > Connection con= > > DriverManager.getConnection("jdbc:db2:track","",""); > > Statement stmt=con.createStatement(); > > > > ResultSet rs=stmt.executeQuery("select * from user"); > > String[] choose=new String[100]; > > int i=0; > > try{ > > while(rs.next()){ > > choose[i]=rs.getString("uname"); > > out.println("<BR>"+choose[i]); > > i++; > > } > > } > > catch(Exception e){} > > out.close(); > > %> > > > > <html> > > <body> > > <select name="ld"> > > <% > > for ( int n = 0; n<i; n++ ) { > > %> > > <option value="<%=choose[i]%>"><%=choose[i]%> > > <% > > } > > %> > > </select> > > </body> > > </html> > > > > > > thanks in advance. > > urs, > > karthik > > > > _________________________________________________________________ > > Help STOP SPAM: Try the new MSN 8 and get 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > ========================================================================== > > = > > 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://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > -- > > It is the strict policy of Truworths that its e-mail facility and all > e-mail communications emanating therefrom, should be utilised for > business purposes only and should conform to high professional and > business standards. Truworths has stipulated certain regulations in > terms whereof strict guidelines relating to the use and content of > e-mail communications are laid down. The use of the Truworths e-mail > facility is not permitted for the distribution of chain letters or > offensive mail of any nature whatsoever. Truworths hereby distances > itself from and accepts no liability in respect of the unauthorised > use of its e-mail facility or the sending of e-mail communications > for other than strictly business purposes. Truworths furthermore > disclaims liability for any unauthorised instruction for which > permission was not granted. Truworths Limited accepts no liability > for any consequences arising from or as a result of reliance on this > message unless it is in respect of bona fide Truworths business for > which proper authorisation has been granted. > > Any recipient of an unacceptable communication, a chain letter or > offensive material of any nature is requested to notify the Truworths > e-mail administrator ([EMAIL PROTECTED]) immediately in order that > appropriate action can be taken against the individual concerned. > > =========================================================================== > 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://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > =========================================================================== 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com