Hi Kamlesh.
The escape sequence in SQL is ' hence you can have '' (i.e. two
apostrope's to put one apostrophe in the DB)
hope this helps.
Regards,
Ankur
k a m l e s h
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
ET.IN> cc:
Sent by: "A mailing Subject: JBBC sql statement problem
list for discussion
about Sun
Microsystem's Java
Servlet API
Technology."
<SERVLET-INTEREST@JAV
A.SUN.COM>
02/07/02 01:35 PM
Please respond to "A
mailing list for
discussion about Sun
Microsystem's Java
Servlet API
Technology."
Hi all,
i have problem while sending query to database if somehow the data filled
in by user in the html form contains words of type hon's as ( ' ) is
delimiter for any char value and sql takes it as delimiter and it creates
problem , please if somebody knows how to solve this do help me
Regards
kamlesh
PS: i want to insert the string in database as it is.
+-------------0000ooo()ooo0000--------------+
| |
| Kamlesh Kr. Sharma Dept. CSA |
| IISc Bangalore-12 |
| Http://www2.csa.iisc.ernet.in/~kamlesh |
| Contact Hostel 80-3092453 Room No. M-111 |
| Contact Dept. 80-3092368. Ext 102 or 115 |
+-------------------------------------------+
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
-----------------------Disclaimer------------------------
The views of the author may not necessarily reflect those
of the Company. All liability is excluded to the extent
permitted by law for any claims arising as a result of the
use of this medium to transmit information by or to
IT Solutions (India) Pvt. Ltd.
We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to
carry out your own virus checks on any attachment to
this message. We cannot accept liability for any loss or
damage caused by software viruses.
------------------------Disclaimer------------------------
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
