Received: from gnumed.dhs.org (modem59.malleenet.net.au [203.143.67.123] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id fB27cZm87745 for ; Sun, 2 Dec 2001 02:38:37 -0500 (EST) (envelope-from hherb@malleenet.net.au) Received: (qmail 28522 invoked by uid 8); 2 Dec 2001 07:38:19 -0000 Message-ID: <20011202073819.28521.qmail@gnumed.dhs.org> Received: from pc-00071.e-smith.gnumed.dhs.org (192.168.1.71, claiming to be "there") by bifrost.e-smith.gnumed.dhs.org with SMTP id smtpdTHGZ1t; Sun, 02 Dec 2001 18:38:12 EST Content-Type: text/plain; charset="iso-8859-1" From: Horst Herb To: "Megalex" Subject: Re: problems with single quotes.. Date: Sun, 2 Dec 2001 18:44:04 +1100 X-Mailer: KMail [version 1.3.2] References: <20011201182212.R74581-100000@megazone23.bigpanda.com> <000b01c07680$29fb2430$0301a8c0@klanomega.com> In-Reply-To: <000b01c07680$29fb2430$0301a8c0@klanomega.com> Cc: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200112/5 X-Sequence-Number: 5828 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