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?