Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8B8EB9FB910 for ; Fri, 16 Mar 2007 06:26:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 99547-03 for ; Fri, 16 Mar 2007 06:26:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout22.attiva.biz (smtpout22.attiva.biz [85.37.16.9]) by postgresql.org (Postfix) with ESMTP id A0AB09FB637 for ; Fri, 16 Mar 2007 06:26:55 -0300 (ADT) Received: from FBCMFE02B12.fbc.local ([192.168.30.89]) by smtpout22.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Fri, 16 Mar 2007 10:26:53 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B12.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Fri, 16 Mar 2007 10:26:53 +0100 Message-ID: <005b01c767ad$3c625970$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: Fw: INSERT INTO Date: Fri, 16 Mar 2007 10:26:53 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-OriginalArrivalTime: 16 Mar 2007 09:26:53.0110 (UTC) FILETIME=[3BA63560:01C767AD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.848 tagged_above=0 required=5 tests=AWL, BAYES_50, INFO_TLD X-Spam-Level: X-Archive-Number: 200703/220 X-Sequence-Number: 27858 thanks.. i will take a look at the link Shavonne Wijesinghe http://www.studioform.it Le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservate e sono, comunque destinate esclusivamente alle persone o alla Società sopra indicati. La diffusione, distribuzione e/o copiature del documento trasmesso da parte di qualsiasi soggetto diverso dal destinatario è proibita, sia ai sensi dell'art. 616 c.p., che ai sensi del D. Lgs. n. 196/2003. Se avete ricevuto questo messaggio per errore, Vi preghiamo di distruggerlo e di informarci immediatamente per telefono allo 0039362595044 o inviando un messaggio all'indirizzo e-mail amministrazione@studioform.it The informations in this communication is confidential and may also be legally privileged. It is intended for the addressee only. Access to this e-mail by anyone else is unauthorized. It is not to be relied upon by any person other than the addressee, except with our prior written approval. If you received this message please send an e-mail to the se ----- Original Message ----- From: "Guillaume Lelarge" To: "Bart Degryse" Cc: ; "Shavonne Marietta Wijesinghe" Sent: Friday, March 16, 2007 10:16 AM Subject: Re: [SQL] INSERT INTO > Bart Degryse a ecrit le 16/03/2007 10:03: >> I don't use ASP but in PHP I would do something in the line of >> $valuetoinsert = "SANT'ANGELO LODIGIANO"; >> $query = "INSERT INTO TABLE2 (TE_INDI) VALUES ('" . str_replace("'", >> "''", $valuetoinsert) . "')"; >> I'm sure ASP has also a string replacement function >> > > This doesn't answer Shavonne's question but, instead of str_replace, you > should better use pg_escape_string : > http://www.php.net/manual/en/function.pg-escape-string.php > > Regards. > > > -- > Guillaume.