7 Dec
2000
7 Dec
'00
12:38 p.m.
On Thursday 7 December 2000, at 13 h 15, the keyboard of Olaf Zanger <olaf.zanger@soli-con.com> wrote:
-> select adr.id,fac.id from fac, adr
It is legal SQL but
->error type: value error ->error value: duplicate column name,id
I believe Zope (not PostgreSQL) needs different names for columns. Otherwise, how would it choose the name of DTML variables? Try renaming the columns with AS in the ZSQL method.