URGENT RE: [Zope] ZmysqlDA

Oliver Marx oliver@tekk.dk
Wed, 29 May 2002 19:43:33 +0200


This is *not* the case.

The query returns a perfect result in mysql.
http://www.mysql.com/doc/J/O/JOIN.html

\Oliver

>>-----Original Message-----
>>From: Chris McDonough [mailto:chrism@zope.com]
>>Sent: 29. maj 2002 19:38
>>To: Oliver Marx
>>Cc: Zope@Zope. Org
>>Subject: Re: URGENT RE: [Zope] ZmysqlDA
>>
>>
>>This has nothing to do with Zope other than the fact that you're
>>carrying out a SQL query via a ZSQL method.  This error message comes
>>from MySQL.  Apparently there's a problem with your syntax.  Maybe MySQL
>>doesn't support this statement?
>>
>>- C
>>
>>On Wed, 2002-05-29 at 13:34, Oliver Marx wrote:
>>> How do you guys/girls do joins?
>>> Am I missing something about Zope?
>>> 
>>> \Oliver
>>> 
>>> >>-----Original Message-----
>>> >>From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
>>> >>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 )
>>> 
>>> 
>>> _______________________________________________
>>> 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 )
>>
>>