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--