Received: from webserver.klanomega.com (cs2424232-238.hot.rr.com [24.242.32.238]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB26vGm86642 for ; Sun, 2 Dec 2001 01:57:20 -0500 (EST) (envelope-from megalex@klanomega.com) Received: from kryodeth (unknown [192.168.1.3]) by webserver.klanomega.com (Postfix) with SMTP id 3261D4B79 for ; Sun, 2 Dec 2001 02:06:27 -0500 (EST) Message-ID: <000b01c07680$29fb2430$0301a8c0@klanomega.com> From: "Megalex" To: References: <20011201182212.R74581-100000@megazone23.bigpanda.com> Subject: problems with single quotes.. Date: Thu, 4 Jan 2001 12:57:19 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200112/4 X-Sequence-Number: 5827 ok.. here is my deal.. everytime i try to run an insert and my text contains '\' it fails.. an sql example would be. Insert Into table(userID,FirstName,LastName) values(1,'''\''','test') and i get this message... Error while executing the query; ERROR: parser: parse error at or near "test" how can i fix this?? Alex,