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
