do you think that i am expecting a parameter without appending a parameter at the end of the url? come on. In my frist postage i already wrote that http://localhost:8080/newscont.jsp?no=1 doesn't work. i just wanted to tell you that it can't see the parameters, even i call it without parameters , i am having the same error, so it can't differentiate if there is a parameter at the end of url or not. anyway still thanks for your (trying) to help me. ----- Original Message ----- From: "Zeng, Feng_Hua (CAP,CEF)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 2:52 PM Subject: Re: help me with this " numberformat exception" please
> Really a strange problem, isn't it? > For your reference, please try the following: > First, try "http://localhost:8080/newscont.jsp?no=123; > Second, check to ensure that the page who calls "newscount.jsp" > correctly uses the METHOD of "POST" or "GET" (with "GET" as default); > At last, I recommend such a coding pattern as follows: > int no = 0; > try { > no = Integer.parseInt(request.getParameter("no")); > } catch (Exception e) { > System.err.println("Exception: " + e); > } > // now the integer variable of "no" can be used carefree > Happy coding! > > -----Original Message----- > From: yilmaz [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 11:46 AM > To: [EMAIL PROTECTED] > Subject: Re: help me with this " numberformat exception" please > > > Thank you David, Horwat and Sankar for your help, > my JSP just can't see the parameters. > i tried calling the jsp without any parameter ( > http://localhost:8080/newscont.jsp) and > i get the same numberformat exception, i think it can't even see that > there is a parameter at the end of the url. What can be wrong ? > according to your advices i changed my code as follows : > <% > > Class.forName("org.gjt.mm.mysql.Driver"); > String no=request.getParameter("no"); /* i also tried with int > no=request.getParameter("no"/no) didn't work either */ > no=no.trim(); > if ((no!=null) && (no.length()!=0)){ > out.println("the value of no : "+ no); > try { > > conn = DriverManager.getConnection("jdbc:mysql:///yilmaz"); > > String sql="select ndate,subject,news from new where no="+no; > stmt = conn.createStatement (sql); > out.println("sql string is :" + sql); > rs = stmt.executeQuery (); .....it goes on... > > still i am having this error : Any idea ??? (:(- > > =========================================================================== > 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