URGENT RE: [Zope] ZmysqlDA
nitin@borwankar.com
nitin@borwankar.com
Wed, 29 May 2002 11:57:59 -0700
--------------080400030105010307020100
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Have you tried select table1.postal_id as id1, table2.postal_id as id2
......
then Zope sees them as id1 and id2, I think
Nitin Borwankar
Oliver Marx wrote:
>This syntaxt is perfetly ok:
>
>select * from table1 left join table2 on table1.postal_id=table2.postal_id
>
>
>
>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://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
>>>** No cross posts or HTML encoding! **
>>>(Related lists -
>>>http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
>>>http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )
>>>
>
>
>_______________________________________________
>Zope maillist - Zope@zope.org
>http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
>** No cross posts or HTML encoding! **
>(Related lists -
> http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
> http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )
>
--------------080400030105010307020100
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<html>
<head>
</head>
<body>
Have you tried select table1.postal_id as id1, table2.postal_id as id2 ......
<pre wrap=""></pre>
<pre wrap=""></pre>
then Zope sees them as id1 and id2, I think<br>
<br>
Nitin Borwankar<br>
<br>
Oliver Marx wrote:<br>
<blockquote type="cite" cite="mid:JHEBKNLGGKLLDDCOJIALOEHDCCAA.oliver@tekk.dk">
<pre wrap="">This syntaxt is perfetly ok:<br><br>select * from table1 left join table2 on table1.postal_id=table2.postal_id<br><br><br><br>Id is reserved in Zope, so I altered the tables.<br><br>But Zope (ZmysqlDA) is still complaining about duplicate column names.<br><br><br>\Oliver<br><br></pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">-----Original Message-----<br>From: <a class="moz-txt-link-abbreviated" href="mailto:zope-admin@zope.org">zope-admin@zope.org</a> [<a class="moz-txt-link-freetext" href="mailto:zope-admin@zope.org">mailto:zope-admin@zope.org</a>]On Behalf Of<br>Dennis Allison<br>Sent: 29. maj 2002 19:52<br>To: Oliver Marx<br>Cc: Zope@Zope. Org<br>Subject: Re: URGENT RE: [Zope] ZmysqlDA<br><br><br><br>Oliver,<br>Check your MySQL documentation and the version of your running <br>MySQL. The Zope DB connection products simply pass the SQL query <br>on to the database management system and report what errors it <br>finds....<br><br><br><br><br>On Wed, 29 May 2002, Oliver Marx wrote:<br><br></pre>
<blockquote type="cite">
<pre wrap="">How do you guys/girls do joins?<br>Am I missing something about Zope?<br><br>\Oliver<br><br></pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Oliver Marx<br>Sent: 29. maj 2002 19:18<br>To: Zope@Zope. Org<br>Subject: [Zope] ZmysqlDA<br><br>select * from table1 left join table2 on table1.id=table2.id <br><br>Error:<br>duplicate column name, id<br><br>Is this an error or a feature?<br><br>\Oliver<br></pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><br><br>_______________________________________________<br>Zope maillist - <a class="moz-txt-link-abbreviated" href="mailto:Zope@zope.org">Zope@zope.org</a><br><a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope</a><br>** No cross posts or HTML encoding! **<br>(Related lists - <br><a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce</a><br><a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev</a> )<br></pre>
</blockquote>
</blockquote>
<pre wrap=""><!----><br><br>_______________________________________________<br>Zope maillist - <a class="moz-txt-link-abbreviated" href="mailto:Zope@zope.org">Zope@zope.org</a><br><a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope</a><br>** No cross posts or HTML encoding! **<br>(Related lists - <br> <a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce</a><br> <a class="moz-txt-link-freetext" href="http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev">http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev</a> )<br></pre>
</blockquote>
<br>
</body>
</html>
--------------080400030105010307020100--