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 fB27nqm87938 for ; Sun, 2 Dec 2001 02:49:52 -0500 (EST) (envelope-from megalex@klanomega.com) Received: from kryodeth (unknown [192.168.1.3]) by webserver.klanomega.com (Postfix) with SMTP id 3DA07211A for ; Sun, 2 Dec 2001 02:59:08 -0500 (EST) Message-ID: <003401c07687$8631ff60$0301a8c0@klanomega.com> From: "Megalex" To: References: <20011201182212.R74581-100000@megazone23.bigpanda.com> <000b01c07680$29fb2430$0301a8c0@klanomega.com> <20011202073819.28521.qmail@gnumed.dhs.org> Subject: Re: problems with single quotes.. Date: Thu, 4 Jan 2001 13:50:01 -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/6 X-Sequence-Number: 5829 i already tried escaping it.. but the problem is with the singlequote-backslash-singlequote combinations.. ----- Original Message ----- From: "Horst Herb" To: "Megalex" Cc: Sent: Sunday, December 02, 2001 1:44 AM Subject: Re: [SQL] problems with single quotes.. > On Friday 05 January 2001 05:57, Megalex wrote: > > > everytime i try to run an insert and my text contains '\' > > it fails.. > > > Insert Into table(userID,FirstName,LastName) values(1,'''\''','test') > > and i get this message... > > > how can i fix this?? > > by escaping the '\' > try > Insert Into table(userID,FirstName,LastName) values(1,'\\','test') > ant it will work > > CHeers, > HOrst