You need to replace ' with 2 ' Rinaldo -----Messaggio originale----- Da: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]] Per conto di Galina K Inviato: gioved� 7 febbraio 2002 17.44 A: [EMAIL PROTECTED] Oggetto: Re: JBBC sql statement problem
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 ___________________________________________________________________________ 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
