You need to insert \ (backslash) before ( ' ). Like ( hon\'s ). ----- Original Message ----- From: "k a m l e s h" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 12:05 AM Subject: JBBC sql statement problem
> 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 > ___________________________________________________________________________ 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
