[Zope-DB] (no subject)
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