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 Mon, 06 Aug 2001 19:25:34 GMT


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


Mime
View raw message