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