thanks Richard. Will
-----Original Message----- From: Richard Yee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 3:08 PM To: [EMAIL PROTECTED] Subject: Re: checking value of parameter from jsp Check Java Man's previous post. This code : if ((name == null) || (name.trim()=="")) won't work. Specifically, you shouldn't compare Strings with ==. A better solution would be if (param == null || "".equals(param.trim())) { "SELECT * FROM name"; } else { sqlstr ="SELECT * FROM name WHERE fname LIKE '"+param + "'"; } Another note to the original poster is that param is not being checked to make sure it contains the '%' wildcard characters. The second query might be changed to sqlstr ="SELECT * FROM name WHERE fname LIKE '"%" + param + "%'"; if that is the case, param should be stripped of all '%' characters. Regards, Richard At 03:16 PM 11/28/2001 -0500, you wrote: >Kwan, > >Your string could be all blanks. > >try testing like: > >String name = request.getParameter ("name"); >if ((name == null) || (name.trim()=="")) > >--amrinder > >_____________________________________________ >From: Kwan, William [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, November 28, 2001 2:54 PM >To: [EMAIL PROTECTED] >Subject: checking value of parameter from jsp > > >Hi all, > >I'm passing information from a html page to a servlet. > >Here is some code: > >String param = request.getParameter("name"); >if (param == null) sqlstr = "Select * from name"; >else sqlstr ="Select * from name where fname like '"+param + "'"; > >and > >if (param == "") sqlstr = "Select * from name"; >else sqlstr ="Select * from name where fname like '"+param + "'"; > >These both dont detect the blank value when they click submit on the jsp >page. It always goes to the else part. > >Am I doing something wrong?? Is there another way to detect if they entered >any data in the field on the form?? > >thanks, >Will > >___________________________________________________________________________ >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > >___________________________________________________________________________ >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
