Or maybe you should try asking the question to the JDBC mailing list instead
of the JSP one!
Frederik Delacourt
-------------------
Senior Software Engineer
Windchill Technology
1200 W. County Road E
Arden Hills, MN 55112
-------------------
"The only good bug is a dead bug !" - Starship Troopers
-------------------
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Andy Noble
> Sent: Wednesday, May 24, 2000 1:29 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Database Help
>
>
> try entering a single quote twice (not a double quote!)
> '%O''hara%';
>
>
> Andy
> ----- Original Message -----
> From: Dominic Choo <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 24, 2000 03:13
> Subject: Database Help
>
>
> > 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
