Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 84391 invoked by uid 500); 7 Aug 2001 08:54:43 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 84380 invoked from network); 7 Aug 2001 08:54:42 -0000 Message-ID: <3B6FAD8E.7050804@i2m.fr> Date: Tue, 07 Aug 2001 10:57:50 +0200 From: =?ISO-8859-1?Q?S=E9bastien?= Lefebvre User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.16-22 i686; en-US; rv:0.9.1) Gecko/20010621 X-Accept-Language: en-us MIME-Version: 1.0 To: cocoon-users@xml.apache.org Subject: Re: Quotes in query References: <20010806092511.J14964@bremen.dvs1.informatik.tu-darmstadt.de> <3B6E540C.80104@i2m.fr> <3B6EEF2E.90EBCD2A@anyware-tech.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N 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. > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: