He's right.
Try:
<input name="firstname" size="30" value="<%= firstname%>">
and
<input name="lastname" size="30" value="<%= lastname%>">
--- Pierre-Yves Saumont <[EMAIL PROTECTED]> wrote:
> The correct form is value = 'Betty Ann'. Unless you put quotes, only the
> first word will show. You will have other problems. If you use single
> quotes, you will sometimes end with something like value='O'Reilly' and it
> will show as O. You have to take care of this and escape all special
> caracters (using entities) before ouputing to HTML. You can use double
> quotes if you are sure your data will never include double quotes, but you
> should not rely on this.
>
> BTW, I suggested to look at the HTML code because doing so, you can see that
> the quotes are missing ;-) (Browsers are very loosy regarding syntax, but
> there should be quotes. Now, you now why !)
>
> Pierre-Yves
>
> -----Message d'origine-----
> De : A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]De la part de
> Barbara Johnson
> Envoy� : vendredi 18 mai 2001 18:10
> � : [EMAIL PROTECTED]
> Objet : Re: jsp text in sql call
>
>
> Thanks for suggesting that I check the generated HTML. Everything is there
> where it is supposed to
> be, i.e. Betty Ann for the firstname is in value = Betty Ann but on the form
> only the Betty shows and not the Ann.
> Any ideas?
> Thanks
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Pierre-Yves Saumont
> Sent: Friday, May 18, 2001 11:08 AM
> To: [EMAIL PROTECTED]
> Subject: Re: jsp text in sql call
>
>
> Hi, Barbara,
>
> Seems that quotes are missing around the values.
>
> When this kind of problem arise, you should have a look at the generated
> HTML. It generally helps finding what's going wrong.
>
> Pierre-Yves
>
> -----Message d'origine-----
> De : A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]De la part de
> Barbara Johnson
> Envoy� : vendredi 18 mai 2001 16:23
> � : [EMAIL PROTECTED]
> Objet : Re: jsp text in sql call
>
>
> Can anyone tell me how to solve this problem?
> I am making a series of forms for an educational application.
> I am able to insert data into a database ok. When I look into MySql the data
> is all there but when I
> repopulate the form from the database, the words are truncated as soon as it
> encounters a space.
>
>
> Here is a sample of my code:
>
>
>
>
> // query statement
> Statement stmt = con.createStatement();
> String queryStr = "SELECT firstname,lastname FROM author";
> ResultSet rs = stmt.executeQuery(queryStr);
>
>
> while (rs.next()){
> String firstname = rs.getString(1);
> String lastname = rs.getString(2);
>
> <!--Repopulate form from database -->
> <FORM name=authorform action="saveauthor.jsp" >
>
> <td>
>
> <input name="firstname" size="30" value=<%= firstname%>>
>
>
> <input name="lastname" size="30" value=<%= lastname%>>
>
> Thank you,
> Barb Johnson
> Instructional Programmer
> Northeast Ohio Universities College of Medicine
>
> ___________________________________________________________________________
> 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
>
> ___________________________________________________________________________
> 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
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
___________________________________________________________________________
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
