Re: [INTERFACES] Still have problem with single quotation mark - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: [INTERFACES] Still have problem with single quotation mark
Date
Msg-id 19990914202435.C5414@gmx.net
Whole thread Raw
In response to Still have problem with single quotation mark  (theofilu@eunet.at (Theofilu Andreas))
List pgsql-interfaces
On Mon, Sep 13, 1999 at 10:11:53PM +0200, Theofilu Andreas wrote:
> There is still a problem with the single quotation mark (') inside a
> string, when this string is inserted into the database and one uses 'ecpg'.
> Someone on this list told me, that I should precede a ' with a second '
> (''). Then it would not be interpreted as the end of string. I did this and
> realy, now it is not interpreted at all. 'ecpg' puts now both quotation
> marks into the database table. This makes for example the words 'I don't
> want this' appear as 'I don''t want this'. Preceding the quotation mark
> with a backslash does not help also. Then I get the SQL error 'too many
> arguments in line xxx'. This is really annoying. How can I fix this?

Which version do you use? There was a quotation problem that should be solved in
the current version. Also how do you feed the date into the statement? As a
char variable or as a constant string?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] Still have problem with single quotation mark
Next
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number