how to convert lowercase letters to higher case while entering
Hai , Does any one know how to convert lowercase letters to higher case while entering only it shouldn't happen after submitting button or with toUpperCase(0 method in Java. Like in Oracle can we have any option to see only uppercase letters in text field? thanks in advance, Murali === 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
Re: how to convert lowercase letters to higher case while enterin g
Hi Murali Mohan, Use this java script function which takes care of converting lower case into upper. // Function which Converts the lowercase letters entered by user to upper case letters function toUpper() { if ((window.event.keyCode=97) (window.event.keyCode=122)) { window.event.keyCode=window.event.keyCode - 32;// Convert to upcase //return true; } }// End of function toUpper() And please don't post question related to Javascript and any other client side scripts here. There are lot of sites out there which will provide you these kind of stuff. Sorry if I am wrong...and thanx for accepting my point. Regards Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:30 AM To: [EMAIL PROTECTED] Subject: how to convert lowercase letters to higher case while entering Hai , Does any one know how to convert lowercase letters to higher case while entering only it shouldn't happen after submitting button or with toUpperCase(0 method in Java. Like in Oracle can we have any option to see only uppercase letters in text field? thanks in advance, Murali === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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
jsp and encoding-autoselect problem with IE
Hi, I am using JSPs and the client is IE 5.5. Now I have a very interesting situation here. In the jsp, I am hiding/showing a button conditionally. Now if I open two separate sessions (two separate browser windows) with different user roles such that in once case , the button should be displayed while in the other window, it should be hidden. It happens exactly like that but when I do a right click near the place of button on the browser which is currently not displaying the button, and change the encoding to auto-select, the button appears on it. Now I cannot understand why the button has come. The html generated by the jsp for this browser window does not contain the button but the button is there on the second window. I hope I made it clear what the problem is. Can anybody suggest who is causing problem? IE??? If yes, how? Regards Nauman === 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
Re: how to convert lowercase letters to higher case while entering
Hai Cockpit , thanks to your reply and advice. Actually I am doing a JSP project. Still I have doubt. Where can I call the function? Means how to call it? User should not see lower case letters. thanks, Murali It, Cockpit (CAP, Contractor) wrote: Hi Murali Mohan, Use this java script function which takes care of converting lower case into upper. // Function which Converts the lowercase letters entered by user to upper case letters function toUpper() { if ((window.event.keyCode=97) (window.event.keyCode=122)) { window.event.keyCode=window.event.keyCode - 32;// Convert to upcase //return true; } }// End of function toUpper() And please don't post question related to Javascript and any other client side scripts here. There are lot of sites out there which will provide you these kind of stuff. Sorry if I am wrong...and thanx for accepting my point. Regards Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:30 AM To: [EMAIL PROTECTED] Subject: how to convert lowercase letters to higher case while entering Hai , Does any one know how to convert lowercase letters to higher case while entering only it shouldn't happen after submitting button or with toUpperCase(0 method in Java. Like in Oracle can we have any option to see only uppercase letters in text field? thanks in advance, Murali === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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
Re: how to convert lowercase letters to higher case while enterin g
YOu can call that function onKeyPress of each text box... or else if you want javascript function to convert it.. toUpperCase is available in Javascript also Thanx Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:20 AM To: [EMAIL PROTECTED] Subject: Re: how to convert lowercase letters to higher case while entering Hai Cockpit , thanks to your reply and advice. Actually I am doing a JSP project. Still I have doubt. Where can I call the function? Means how to call it? User should not see lower case letters. thanks, Murali It, Cockpit (CAP, Contractor) wrote: Hi Murali Mohan, Use this java script function which takes care of converting lower case into upper. // Function which Converts the lowercase letters entered by user to upper case letters function toUpper() { if ((window.event.keyCode=97) (window.event.keyCode=122)) { window.event.keyCode=window.event.keyCode - 32;// Convert to upcase //return true; } }// End of function toUpper() And please don't post question related to Javascript and any other client side scripts here. There are lot of sites out there which will provide you these kind of stuff. Sorry if I am wrong...and thanx for accepting my point. Regards Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:30 AM To: [EMAIL PROTECTED] Subject: how to convert lowercase letters to higher case while entering Hai , Does any one know how to convert lowercase letters to higher case while entering only it shouldn't happen after submitting button or with toUpperCase(0 method in Java. Like in Oracle can we have any option to see only uppercase letters in text field? thanks in advance, Murali === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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
Re: how to convert lowercase letters to higher case while entering
Thank you very much. I got it. It, Cockpit (CAP, Contractor) wrote: YOu can call that function onKeyPress of each text box... or else if you want javascript function to convert it.. toUpperCase is available in Javascript also Thanx Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:20 AM To: [EMAIL PROTECTED] Subject: Re: how to convert lowercase letters to higher case while entering Hai Cockpit , thanks to your reply and advice. Actually I am doing a JSP project. Still I have doubt. Where can I call the function? Means how to call it? User should not see lower case letters. thanks, Murali It, Cockpit (CAP, Contractor) wrote: Hi Murali Mohan, Use this java script function which takes care of converting lower case into upper. // Function which Converts the lowercase letters entered by user to upper case letters function toUpper() { if ((window.event.keyCode=97) (window.event.keyCode=122)) { window.event.keyCode=window.event.keyCode - 32;// Convert to upcase //return true; } }// End of function toUpper() And please don't post question related to Javascript and any other client side scripts here. There are lot of sites out there which will provide you these kind of stuff. Sorry if I am wrong...and thanx for accepting my point. Regards Yogaraj -Original Message- From: Murali Mohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:30 AM To: [EMAIL PROTECTED] Subject: how to convert lowercase letters to higher case while entering Hai , Does any one know how to convert lowercase letters to higher case while entering only it shouldn't happen after submitting button or with toUpperCase(0 method in Java. Like in Oracle can we have any option to see only uppercase letters in text field? thanks in advance, Murali === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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 THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system. === 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
Question about page parameters type. String?
Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia ==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
Re: Question about page parameters type. String?
hi, check like this it will work if(color.equals(red) regards Sasi. - Original Message - From: Villén Pizarro, Julia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:22 PM Subject: Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = 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
Re: Question about page parameters type. String?
No need of casting as paramater always comes as a String and your color variable in the code is also a String so no need of casting. -Original Message- From: Villén Pizarro, Julia [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:22 PM To: [EMAIL PROTECTED] Subject: Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = 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
Re: Question about page parameters type. String?
Thanks a lot for such fast answers. Julia -Mensaje original- De: sbpodila [mailto:[EMAIL PROTECTED]] Enviado el: jueves, 18 de abril de 2002 14:04 Para: [EMAIL PROTECTED] Asunto: Re: Question about page parameters type. String? hi, check like this it will work if(color.equals(red) regards Sasi. - Original Message - From: Villén Pizarro, Julia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:22 PM Subject: Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = 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 ==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
Re: Question about page parameters type. String?
Try this % String color; color=request.getParameter(color) if (color.equals(red) { whatever1 } else {whatever2} % Regards Ramesh Kesavanarayanan Off : 91-44-8113801 ext 2333 Tel:91-44-2265360 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Villén Pizarro, Julia [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:22 PM To: [EMAIL PROTECTED] Subject:Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia ==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
Re: Question about page parameters type. String?
Hi bhusan, That's one point but she is trying to compare using == method which is for object referecne but not the value. No need of casting as paramater always comes as a String and your color variable in the code is also a String so no need of casting. -Original Message- From: Villén Pizarro, Julia [mailto:[EMAIL PROTECTED]] mailto:[mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:22 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject:Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com http://www.jspinsider.com ==To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com 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
Re: Cellpadding
-- Virus Warning Message (on VirusWall.udngroup.com.tw.) Unknown command - "--". Try HELP. Found virus WORM_KLEZ.G in file width.scr Unknown command - "FOUND". Try HELP. The uncleanable file is deleted. Unknown command - "THE". Try HELP. - Unknowncommand - "-". Try HELP. === 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
SQL SELECT Problem
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 worlds 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
Re: SQL SELECT Problem
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
Re: SQL SELECT Problem
It looks like you need something like: ResultSet rs = ... your executeQuery() here ... String Username = rs.getString(Username); As the code you sent has it, there is nothing to hold the result of your query. Bob -Original Message- From: Graeme McLaren [mailto:[EMAIL PROTECTED]] 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+); -- sql=SELECT Username FROM join11 WHERE(' +EappName+ ', ' +EappSurname+ ', ' +address+ ', ' +TownCity+ ', ' +Postcode+ ', ' +Phone+ ', ' +email+ ' ); out.println(p+Username+/p); === 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
[ANN] First two beta Chapters of O'Reilly Struts Book Available for Download
I just wanted to let everyone know that the first two beta chapters from my OReilly Struts book are available for download from http://www.theserverside.com. You have to register an account to be able to download the chapters. This is their policy, not mine. I believe this is true even if you wanted to join the discussion group or post a question. The chapters have not been through a formal editing process yet. Therefore, you will find typos, run-ons, fragments, and various other incorrect usages of the English language. All of the chapters will eventually go through a formal review by individuals that spent four or more years of their lives learning how to construct a proper sentence, for which I have yet to figure out. The purpose of providing the chapters so early is twofold. The first reason is to get the material to the community as quickly as possible. There have been a multitude of new features added to the framework for 1.1, and hopefully the information within the book will be valuable to the developer community. Obviously, I incur great peril in doing this, in the off chance that I stink as a writer. Hopefully, you wont find that to be true. But in either case, dont worry; everything will be edited before being published. The other reason to allow the chapters to be made public before they are final is to ask anyone that cares to participate, to help out in the editing process. The chapters are in MS Word format, with the track changes option on. As you type in the document, your text should appear in a different color, which allows me to see your recommended changes. Once you have completed any changes, suggestions, or just general comments on how good the chapter is (I hope), just email a copy of the resulting document to: [EMAIL PROTECTED] Feel free to correct any general language problems that you find. More importantly however, if you see any confusing sections, technical mistakes, or would like me to add something that is not there, that would be very beneficial. Where appropriate, Ive also included the source code for the chapter within the ZIP file that you download. Feel free to view it, modify it, or reuse it, as you need. In some cases, entire web applications are included, along with ant build scripts. If you detect problems or issues there, feel free to mention those in the document as well. I will incorporate all of the changes back into the master document. You might ask, What do I get for doing this? This is the great thing about being an editor (ask any of them), you get the satisfaction of knowing you helped to make a published work better. Of course, you also get to keep the word documents for reference, as long as you promise to buy a copy of the book, (Just kidding on that part!) and everyone will get a collective thank you in the acknowledgments of the book. Unfortunately, I wont be able to thank everyone personally, but if anyone goes beyond the call of duty, I will add a personal thank you. Space is limited on this page, I have a wife and three boys to thank, or they will kick me out of the house. I will make new chapters available every few weeks on the site, and this will go on until all of the chapters have been edited and sent off to the printer. Theres no real schedule right now as to which chapters will be available when. I have to be careful that it doesnt impact my overall schedule, which I must hit. I have received a great deal of input from everyone about which chapters are the most important to them and I will try to follow that order, as long as it makes sense from the standpoint of the table of contents. There are dependencies in writing books, just as there are in software. I hope everyone gets some value out of this. It will definitely make the book much, much, better than it would be on its own. Thanks, Chuck ==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
Re: SQL SELECT Problem
Pls make your intention clear. The problem seems to be Username is not declared. Also I doubt whether the query is well formed. Pls post the entire source code. ASalam. - Original Message - From: Graeme McLaren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:44 PM Subject: SQL SELECT Problem 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
To the CLASSPATH environment variable.
Mailsuite WebShield Antivirus V4.5 MR1a on SMTP Server detected virus Exploit-MIME.gen in attachment unknown from [EMAIL PROTECTED] and it was Cleaned. === 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
Re: Question about page parameters type. String?
or a much faster way is like this % String color; color=request.getParameter(color) if (color.intern() ==red) { -- whatever1 } else {whatever2} % using intern() is quite fast since in equals() each character is checked which is quite time consuming which intern() gives you the canonical representation of the string. in your applications try to use intern() rather than equals(). Regards, Vikramjit Singh, Systems Engineer, GTL Ltd. Ph. 7612929-1031 -Original Message- From: Kesav, Ramesh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:19 AM To: [EMAIL PROTECTED] Subject: Re: Question about page parameters type. String? Hi bhusan, That's one point but she is trying to compare using == method which is for object referecne but not the value. No need of casting as paramater always comes as a String and your color variable in the code is also a String so no need of casting. -Original Message- From: Villén Pizarro, Julia [mailto:[EMAIL PROTECTED]] mailto:[mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:22 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject:Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com http://www.jspinsider.com ==To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com 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 ==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
Re: Question about page parameters type. String?
Hi, I was seeing the description of the intern() method , and could not understand how it can be faster than equal() method. As intern() internally calls the equal method . Am I correct ?? Regds Ashwani - Original Message - From: Vikramjit Singh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 9:24 AM Subject: Re: Question about page parameters type. String? or a much faster way is like this % String color; color=request.getParameter(color) if (color.intern() ==red) { -- whatever1 } else {whatever2} % using intern() is quite fast since in equals() each character is checked which is quite time consuming which intern() gives you the canonical representation of the string. in your applications try to use intern() rather than equals(). Regards, Vikramjit Singh, Systems Engineer, GTL Ltd. Ph. 7612929-1031 -Original Message- From: Kesav, Ramesh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:19 AM To: [EMAIL PROTECTED] Subject: Re: Question about page parameters type. String? Hi bhusan, That's one point but she is trying to compare using == method which is for object referecne but not the value. No need of casting as paramater always comes as a String and your color variable in the code is also a String so no need of casting. -Original Message- From: Villén Pizarro, Julia [mailto:[EMAIL PROTECTED]] mailto:[mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:22 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject:Question about page parameters type. String? Hi all! I call my_page.jsp this way http://my_server/my_page.jsp?color=red http://my_server/my_page.jsp?color=red Then I retrieve the value of the parameter color and then try to match it, in the following way: % String color; color=request.getParameter(color) if (color==red) { whatever1 } else {whatever2} % The answer is whatever2. I made sure the page is getting the parameter right by writing it out. The question is if I have to do any kind of casting. Thaks in advance, Julia = To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com http://www.jspinsider.com ==To unsubscribe: mailto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com 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 = 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
Re: SQL SELECT Problem
No its wrong sql = SELECT Username FROM join11 WHERE eappname = ' +EappName+ ' and eappsurname = ' +EappSurname+ ' and address= ' +address+ ' and towncity = ' +TownCity+ ' and postcode = ' +Postcode+ 'and phone = ' +Phone+ 'and email = ' +email+ '; After this query execute it and get the Username as String Username = rs.getString(Username); then only you can say out.println(p+Username+/p); Since you never defined the Username variable in your JSP, you were getting compile time error. -Original Message- From: Kesav, Ramesh [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 11:14 AM To: [EMAIL PROTECTED] Subject: Re: SQL SELECT Problem May be the query should look like this sql=SELECT Username FROM join11 WHERE eappname = (' +EappName+ ' and eappsurname = ' +EappSurname+ ' and address= ' +address+ 'and towncity = ' +TownCity+ ' and postcode = ' +Postcode+ 'and phone = ' +Phone+ 'and email = ' +email+ ' ); Regards Ramesh Kesavanarayanan Off : 91-44-8113801 ext 2333 Tel:91-44-2265360 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: ASALAM [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:46 AM To: [EMAIL PROTECTED] Subject:Re: SQL SELECT Problem Pls make your intention clear. The problem seems to be Username is not declared. Also I doubt whether the query is well formed. Pls post the entire source code. ASalam. - Original Message - From: Graeme McLaren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:44 PM Subject: SQL SELECT Problem 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 === 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