Sébastien Lefebvre wrote:
>
> Hi all,
>
> I have a form where I can type text.
> The form is submited with post method to a xsp page.
> This texte can of course have quotes in it. ex: I'd like this to work
> How to insert it in MySQL ?
> Do I have to write XSP logic in order to replace ' by \' ?
> Or is there any other solution ?
> (I'd like to make the operation server side so javascript's regexp is
> not an issue for me).
>
> Thanks in advance
> Sébastien
>
Use a PreparedStatement to insert your String, the JDBC driver will take
care of this if needed. This will also increase the portability of your
code, since escaping syntax varies between databases.
--
Sylvain Wallez
Anyware Technologies - http://www.anyware-tech.com
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>