On Thursday 7 December 2000, at 13 h 15, the keyboard of Olaf Zanger
<[EMAIL PROTECTED]> 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.
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )