Hi, U have a Class in java.net.URLEncoder. It codes all your special characters and you store in database while rertreving JSP takes care converting all the special characters back.
Regards. ----- Original Message ----- From: Miao, Franco CAWS:EX <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 3:07 PM Subject: Re: SQL apostrophie INSERT problem > in SQL you can "delete" the data base on your criteria and "update" with the > replacement > > Franco > > -----Original Message----- > From: Andrew Bruno [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 6:28 PM > To: [EMAIL PROTECTED] > Subject: SQL apostrophie INSERT problem > > > Could anyone direct me to any methods that can be used to filter a > string which is to be inserted into an SQL table. > > For example, if the string contains an apostrophie, I need to replace it > with an escape charatcter. Are there methods in the API that can take > care of this, or should I write my own? > > ~Andrew > > =====================================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
