cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Wallez <sylvain.wal...@anyware-tech.com>
Subject Re: Quotes in query
Date Tue, 07 Aug 2001 18:26:28 GMT


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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message