URGENT RE: [Zope] ZmysqlDA

[Oliver Marx]

This syntaxt is perfetly ok:

select * from table1 left join table2 on table1.postal_id=table2.postal_id

http://www.mysql.com/doc/J/O/JOIN.html

Id is reserved in Zope, so I altered the tables.

But Zope (ZmysqlDA) is still complaining about duplicate column names.


\Oliver

>>-----Original Message-----
>>From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
>>Dennis Allison
>>Sent: 29. maj 2002 19:52
>>To: Oliver Marx
>>Cc: Zope@Zope. Org
>>Subject: Re: URGENT RE: [Zope] ZmysqlDA
>>
>>
>>
>>Oliver,
>>Check your MySQL documentation and the version of your running 
>>MySQL.  The Zope DB connection products simply pass the SQL query 
>>on to the database management system and report what errors it 
>>finds....
>>
>>
>>
>>
>>On Wed, 29 May 2002, Oliver Marx wrote:
>>
>>> How do you guys/girls do joins?
>>> Am I missing something about Zope?
>>> 
>>> \Oliver
>>> 
>>> >>Oliver Marx
>>> >>Sent: 29. maj 2002 19:18
>>> >>To: Zope@Zope. Org
>>> >>Subject: [Zope] ZmysqlDA
>>> >>
>>> >>select * from table1 left join table2 on table1.id=table2.id 
>>> >>
>>> >>Error:
>>> >>duplicate column name, id
>>> >>
>>> >>Is this an error or a feature?
>>> >>
>>> >>\Oliver
>>
>>
>>
>>_______________________________________________
>>Zope maillist  -  Zope@zope.org
>>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 )