Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 85A029FBB03 for ; Fri, 16 Mar 2007 05:50:35 -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 91279-05 for ; Fri, 16 Mar 2007 05:50:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout17.attiva.biz (smtpout17.attiva.biz [85.37.16.19]) by postgresql.org (Postfix) with ESMTP id 5F1C69FB910 for ; Fri, 16 Mar 2007 05:50:30 -0300 (ADT) Received: from FBCMFE02B15.fbc.local ([192.168.30.161]) by smtpout17.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Fri, 16 Mar 2007 09:50:28 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B15.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Fri, 16 Mar 2007 09:50:19 +0100 Message-ID: <002c01c767a8$20d5d600$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: INSERT INTO Date: Fri, 16 Mar 2007 09:50:20 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0029_01C767B0.823D50F0" 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 08:50:19.0250 (UTC) FILETIME=[2001BD20:01C767A8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.695 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200703/217 X-Sequence-Number: 27855 This is a multi-part message in MIME format. ------=_NextPart_000_0029_01C767B0.823D50F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello I have 2 tables. TABLE1 and TABLE2. TABLE1 has about 400 records with details (client code, name, surname, = address, date of birth) of my clients. TABLE2 is filled with some of the client details and other extra details = (client code, address, telephone, etc) So in my ASP page i have a select that gets the client details from = TABLE1 using the client code and inserts them in to TABLE2 When i have a string that has a ' inside of it the record is not = inserted in to TABLE2. I know that writing it twice will fix it but how = can i ask my ASP code to do it.. INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO'); Thanks Shavonne Wijesinghe http://www.studioform.it =20 ------=_NextPart_000_0029_01C767B0.823D50F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello
 
I have 2 tables. TABLE1 and = TABLE2.
 
TABLE1 has about 400 records with = details (client=20 code, name, surname, address, date of birth) of my clients.
TABLE2 is filled with some of the = client details=20 and other extra details (client code, address, telephone, = etc)
 
So in my ASP page i have a select that = gets the=20 client details from TABLE1 using the client code and inserts them in to=20 TABLE2
 
When i have a string that has a ' = inside of it the=20 record is not inserted in to TABLE2. I know that writing it twice will = fix it=20 but how can i ask my ASP code to do it..
 
INSERT INTO TABLE2 (TE_INDI) = VALUES=20 ('SANT'ANGELO LODIGIANO');
 
Thanks
 
Shavonne Wijesinghe
http://www.studioform.it
 
 
------=_NextPart_000_0029_01C767B0.823D50F0--