[Zope] RE: [Psycopg] \'s in ZSQL methods with Postgresql

[Mayers, Philip J]

Ok, thanks.

Regards,
Phil

+----------------------------------+
| Phil Mayers, Network Support     |
| Centre for Computing Services    |
| Imperial College                 |
+----------------------------------+  

-----Original Message-----
From: Federico Di Gregorio [mailto:fog@mixadlive.com]
Sent: 04 May 2001 16:05
To: Mayers, Philip J
Cc: 'psycopg@lists.initd.org'; 'zope@zope.org'
Subject: Re: [Psycopg] \'s in ZSQL methods with Postgresql


Scavenging the mail folder uncovered Mayers, Philip J's letter:
> This:
> 
> update tb1 set cl1=<dtml-sqlvar val1 type=nb>,who=<dtml-sqlvar
> "REQUEST.AUTHENTICATED_USER">,time=now()
> 
> Called with:
> 
> sqlmethod(val1='\')
> 
> Fails with:
> 
> Error Type: ProgrammingError
> Error Value: ERROR: parser: parse error at or near "loginname" update tb1
> set cl1='\',who='loginname',time=now()
> 
> Clearly the \ needs to be escaped. Is this Postgres specific? If so, why
> isn't the DA (ZPsycopg) quoting it? Running Zope 2.3.2

you are right, quoting will be fixed in the next release (we use psycopg
much more than ZPsycopgDA, so this one still has some rought edges...)
btw, what does 'type=nb' means? (i only know of string and int...)

ciao,
federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Try the Joy of TeX [http://www.tug.org]
                                      -- brought to you by One Line Spam