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