Check out Section 9 - JSP Comments and Character Escaping Conventions at
this web site:
http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/Servlet-Tutorial-JSP.html
<http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/Servlet-Tutorial-JSP.htm
l>

Mark



                -----Original Message-----
                From:   Julia Reynolds
[mailto:[EMAIL PROTECTED]]
                Sent:   Wednesday, July 19, 2000 3:55 PM
                To:     [EMAIL PROTECTED]
                Subject:        escaping single quotes in JSP embedded SQL

                This is a basic question!  When you have a SQL INSERT
statement embedded
                directly in a page, and some of the insert values include
single quotes,
                how in JSP
                do we handle the need to escape (double up) the single
quotes to avoid
                an ODBC
                error.  In VB we just replace the single quotes with two
single quotes.
                Is it the same
                in JSP?  Should I just append in another single quote?

                Julia


===========================================================================
                To unsubscribe: mailto [EMAIL PROTECTED] with body:
"signoff JSP-INTEREST".
                Some relevant FAQs on JSP/Servlets can be found at:

                 http://java.sun.com/products/jsp/faq.html
                 http://www.esperanto.org.nz/jsp/jspfaq.html
                 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
                 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to