If you use PreparedStatement instead of Statement, this problem is
automatically taken care of in a cross-platform way.
-----Original Message-----
From: ramadevi [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 24, 2000 8:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Database Help
hai
you can do it like this
first set the escape on by issuing
set escape on ,then
select * from sample where name='o\''reily';
Dominic Choo wrote:
> I would like to ask anyone the help me to solve this SQL
command problem.
> For example:
>
> Select * from Personal where Name like '%O'hara%';
>
> This SQL command will produce an error because the
existance of the " ' "
> character in the "O'hara" word.
> Please help me to solve this problem...... Thanx!
>
> Choo Khai Shien, Dominic
>
> ---
> Disclaimer note:
> Confidential information may be contained in the e-mail
and any files
> transmitted with it ('Message'). If you are not the
addressee indicated in
> this Message (or responsible for the delivery of this
Message to such
> person), you are hereby notified that any dissemination,
distribution,
> printing or copying of this Message or any part thereof is
strictly
> prohibited. In such a case, you should delete this Message
immediately and
> advise the sender by return e-mail. Opinions, conclusions
and other
> information in this Message that do not relate to the
official business of
> e-BX nor any of its related companies shall be understood
as neither given
> nor endorsed by e-BX nor any of its related companies.
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
"signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body:
"signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets