[Zope-DB] (no subject)

Martin Gebert Murphy@members.netsolution-net.de
Thu, 19 Dec 2002 12:46:20 +0100


Matthew T. Kromer schrieb:

>
> On Thursday, December 19, 2002, at 06:00 AM, Gareth Evans wrote:
>
>>
>> auto    trap    datestamp    trapoid    trapfull    target    
>> enterprise    community     generictrap    specifictrap    version    
>> severity    ack    auto    var    num
>> 4    LINKDOWN    2002-12-17  16:52:36    0    NULL    
>> 192.0.2.1/161    NULL    NULL    NULL    NULL    NULL    1    0    
>> 4    4    1
>>
>>
> You'll note the column "auto" shows up twice in your results, because  
> you ask for it from both tables.  Zope doesn't know that it is the 
> same  column, constrained by the join, so it complains.

That's my best guess, too.

>
> You can use Select column AS column1 notation to work around this,  
> although that is more clumsy to type.

Suggestion: It would be more clean to select only the fields you really 
need by name, instead of selecting all (at least that's what some 
Professors and SQL books say ;-). This would also get rid of that 
overlapping names.

Martin