Sébastien Lefebvre wrote:
>
> Sylvain ,
>
> Thank you for your prompt answer.
> As far as I'm new to Cocoon, could you send me a piece of code ?
> It will help me very much.
>
> Thanks again
>
> Sébastien
>
> >
> >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.
> >
>
If you're using JDBC calls, you should have a look at the dedicated
section of the excellent Java tutorial at
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html
It is explained here certainly better than I could do !
If you're using the esql logicsheet, I cannot be of great help since I
don't use it, but Christian told that <esql:parameter> generates
prepared statements.
--
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]>
