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