Hi Alexander
Just replace single quote with double quote.
-M.Chitra
www.3rdagenda.com
At 12:10 PM 10/24/01 +0900, you wrote:
>How can I escape quotes in SQL string which may contain:
>
>INSERT INTO MYTABLE (TITLE) VALUES ('Blah'blah'blah')
>
>those single quotes throw an error
>is there easy way to replace those single quotes?
>
>with best wishes
>Alexander Kachanov
>
>
>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
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01
