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
