Graeme,
It appears to be a Java syntax error and not an SQL problem. (Though I
question the contents of your WHERE clause). You don't have a Username
variable declared in the code you sent.
Regards,
Richard
At 07:14 PM 4/18/2002 +0100, you wrote:
>Hi all, thank you for all the replies to my earlier SQL question, I've now
>managed to INSERT data to my database. Now I have a problem selecting the
>data which I have inserted.
>
>I have a form which is to be filled out to retrieve a username when a user
>fills in their personal details. I'm getting the following error:
>
> 97. out.println(""+Username+"");
> <------>
>*** Error: No entity named "Username" was found in this environment.
>
>In my JSP I have:
>
>String EappName=request.getParameter("EappName");
>String EappSurname=request.getParameter("EappSurname");
>String address=request.getParameter("address");
>String TownCity=request.getParameter("TownCity");
>String Postcode=request.getParameter("Postcode");
>String Phone=request.getParameter("Phone");
>String email=request.getParameter("email");
>
>sql="SELECT Username FROM join11 WHERE('" +EappName+ "', '" +EappSurname+
>"', '" +address+ "', '" +TownCity+ "', '" +Postcode+ "', '" +Phone+ "', '"
>+email+ "' )";
>
>out.println("<p>"+EappName+"</p>");
>out.println("<p>"+EappSurname+"</p>");
>out.println("<p>"+address+"</p>");
>out.println("<p>"+TownCity+"</p>");
>out.println("<p>"+Postcode+"</p>");
>out.println("<p>"+Phone+"</p>");
>out.println("<p>"+Username+"</p>");
>out.println("<p>"+email+"</p>");
>
>What has gone wrong here? Any advice is greatly appreciated.
>
>Thank you in advance,
>
>Graeme :)
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.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
===========================================================================
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
