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 )

Reply via email to