I am using the pgadmin windows tool with the latest PsqlODBC drivers.
The problem seems to be, that running a query with escaped quotes like
[Select * from test where xyz like 'pete\'s cafe'] doesnt work, but
using 2 single quotes works: [Select * from test where xyz like 'pete''s
But I can run both queries on the psql command line interface on linux.
Can this be a problem with the ODBC or is there a setting that can be
changed to also allow both ways?
pgsql-interfaces by date
|Next:||From: Peter Mount||Date: 2000-04-11 09:49:19|
|Subject: RE: ODBC and crypted passwords |
|Previous:||From: Byron Nikolaidis||Date: 2000-04-11 03:50:29|
|Subject: Re: query from Murty|