troubleshooting Question

Problems with " and '

Avatar of coincidence
coincidence asked on
Java
13 Comments1 Solution228 ViewsLast Modified:
I have a jsp variable that is created by a user entering data into a text area. On the nex t page another JSP page uses a getParameter to obtain the  data entered into the previously entered data. The data is transfered to a  HSQL database. I am having major problems with the code generating  errors :

A standard SQL type exception was encountered: java.sql.SQLException: Unexpected token:

when a user uses a '  (single quote) or " (double quote). Is there a way to get around this?

Does anyone have a solution to this problem? Either through Javascript or throgh a JSP solutions itself?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros