Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 25686 invoked by uid 500); 7 Aug 2001 16:25:13 -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 25662 invoked from network); 7 Aug 2001 16:25:13 -0000 Message-ID: <3B7032D4.EFF90C31@anyware-tech.com> Date: Tue, 07 Aug 2001 18:26:28 +0000 From: Sylvain Wallez Organization: Anyware Technologies X-Mailer: Mozilla 4.77 [en] (Win98; U) X-Accept-Language: en 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> <3B6FAD8E.7050804@i2m.fr> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N 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 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. To unsubscribe, e-mail: For additional commands, e-mail: