-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Weird didn't see the answer in here... I use a PreparedStatement, and usually that takes care of all the SQL for you, including SQL encoding of any single quotes in your text. Let us know if you need to see an example. R On Thursday, September 5, 2002, at 07:59 AM, techhead4life wrote: > No problemo~ > > ----- Original Message ----- > From: "Mahesh Gangarapu" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, September 05, 2002 1:13 AM > Subject: Re: JSP Apostrophe in JDBC > > >> Thanks >> >> -----Original Message----- >> From: A mailing list about Java Server Pages specification and >> reference >> [mailto:[EMAIL PROTECTED]] On Behalf Of techhead4life >> Sent: Thursday, September 05, 2002 10:42 AM >> To: [EMAIL PROTECTED] >> Subject: Re: JSP Apostrophe in JDBC >> >> [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer] Line 1: >> Incorrect >> syntax near 's'. >> >> ----- Original Message ----- >> From: "Benoit Jodoin" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Wednesday, September 04, 2002 11:36 PM >> Subject: Re: JSP Apostrophe in JDBC >> >> >>> Can you give us your error msg plz?:) >>> >>> At 11:33 PM 9/4/2002 -0400, you wrote: >>>> I am getting an error when updating some input text records using a >> form >>>> >>>> When I enter an Apostrophe in the text fields and send to the jsp >> page >>>> which update the record in the db, it causes an error on the sql >>>> jdbc >> call. >>>> >>>> How do you treat Apostrophe in jsp, esp when sql is involved ? >>>> >>>> >>>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >>>> JSP-INTEREST". >>>> For digest: mailto [EMAIL PROTECTED] with body: "set >>>> JSP-INTEREST >> DIGEST". >>>> Some relevant FAQs on JSP/Servlets can be found at: >>>> >>>> http://archives.java.sun.com/jsp-interest.html >>>> http://java.sun.com/products/jsp/faq.html >>>> http://www.esperanto.org.nz/jsp/jspfaq.jsp >>>> http://www.jguru.com/faq/index.jsp >>>> http://www.jspinsider.com >>> >>> >> ====================================================================== >> == >> === >>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >> JSP-INTEREST". >>> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >> DIGEST". >>> Some relevant FAQs on JSP/Servlets can be found at: >>> >>> http://archives.java.sun.com/jsp-interest.html >>> http://java.sun.com/products/jsp/faq.html >>> http://www.esperanto.org.nz/jsp/jspfaq.jsp >>> http://www.jguru.com/faq/index.jsp >>> http://www.jspinsider.com >> >> ====================================================================== >> == >> === >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >> JSP-INTEREST". >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >> DIGEST". >> Some relevant FAQs on JSP/Servlets can be found at: >> >> http://archives.java.sun.com/jsp-interest.html >> http://java.sun.com/products/jsp/faq.html >> http://www.esperanto.org.nz/jsp/jspfaq.jsp >> http://www.jguru.com/faq/index.jsp >> http://www.jspinsider.com >> >> > > ======================================================================= > ==== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > Robert S. Sfeir Senior Java Engineer PGP Key available at: pgpkeys.mit.edu KeyID: 128C88C7 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (Darwin) iD8DBQE9d0nuAP6i6RKMiMcRAqK5AJ968bc6JRATXKH5n5D+GI6IbukT6gCfS41n f5rcX3pJ5K+Scgdp1dx7C98= =27+N -----END PGP SIGNATURE----- =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
