[Zope] \'s in ZSQL methods with Postgresql

4 May 2001

      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

Regards,
Phil

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

[Zope] \'s in ZSQL methods with Postgresql

Mayers, Philip J