use PreparedStatement, and let it handle the apostrophes.... > -----Original Message----- > From: Benoit Jodoin [SMTP:[EMAIL PROTECTED]] > Sent: 05 September 2002 03:10 > To: [EMAIL PROTECTED] > Subject: Re: JSP Apostrophe in JDBC > > It's a solution i've found...what would you suggest?..how do you let the > driver do it? > > At 05:33 AM 9/5/2002 -0500, you wrote: > >Works just fine for YOU, with SQL Server. Other DBs don't do the same > thing > >(although most do) and it's slower than letting the DB driver do it. > > > > > >>From: Benoit Jodoin <[EMAIL PROTECTED]> > >>Reply-To: A mailing list about Java Server Pages specification and > >>reference <[EMAIL PROTECTED]> > >>To: [EMAIL PROTECTED] > >>Subject: Re: JSP Apostrophe in JDBC > >>Date: Thu, 5 Sep 2002 01:14:45 -0400 > >> > >>Try replacing your single quote with 2 single quotes..works just fine > for > >>me with sqlserver. > >> > >>Regards > >> > >>Ben > >> > >>At 01:12 AM 9/5/2002 -0400, you wrote: > >>>[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 > > > > > >----------------------------------------------- > >Joseph B. Ottinger [EMAIL PROTECTED] > >http://enigmastation.com IT Consultant > > > >_________________________________________________________________ > >MSN Photos is the easiest way to share and print your photos: > >http://photos.msn.com/support/worldwide.aspx > > > >========================================================================= > == > >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 --
It is the strict policy of Truworths that its e-mail facility and all e-mail communications emanating therefrom, should be utilised for business purposes only and should conform to high professional and business standards. Truworths has stipulated certain regulations in terms whereof strict guidelines relating to the use and content of e-mail communications are laid down. The use of the Truworths e-mail facility is not permitted for the distribution of chain letters or offensive mail of any nature whatsoever. Truworths hereby distances itself from and accepts no liability in respect of the unauthorised use of its e-mail facility or the sending of e-mail communications for other than strictly business purposes. Truworths furthermore disclaims liability for any unauthorised instruction for which permission was not granted. Truworths Limited accepts no liability for any consequences arising from or as a result of reliance on this message unless it is in respect of bona fide Truworths business for which proper authorisation has been granted. Any recipient of an unacceptable communication, a chain letter or offensive material of any nature is requested to notify the Truworths e-mail administrator ([EMAIL PROTECTED]) immediately in order that appropriate action can be taken against the individual concerned. =========================================================================== 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
