[Zope-DB] (no subject)

[Gareth Evans]

hi I'm using=20
(Zope 2.5.1 (binary release, python 2.1, win32-x86), python 2.1.3, =
win32)=20
with
ZMySQLDA (Installed product ZMySQLDA (ZMySQLDA 2.0.8))  =
<ZMySQLDA/manage_workspace>
this seems to work fine for simple selects inserts etcetera but I'm =
trying to do the following join in a z sql method


select * from snmp_trap_entry, snmp_trap_vars where =
snmp_trap_vars.auto=3Dsnmp_trap_entry.auto and snmp_trap_vars.auto=3D4

I get the following failure
Error Type: ValueError
Error Value:=20
Voyager Error Voyager has encountered an error while publishing this =
resource. Error Type: ValueError Error Value: Duplicate column name, =
auto=09

the above command works fine when I run it from the mysql prompt

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



describe of snmp_trap_vars
Field	Type	Null	Key	Default	Extra
auto	int(11)	YES		NULL=09
var	char(50)	YES		NULL=09
num	int(11)	YES		NULL=09

describe of snmp_trap_entry
Field	Type	Null	Key	Default	Extra
auto	int(11)		PRI	NULL	auto_increment
trap	char(50)	YES		NULL=09
datestamp	datetime	YES		NULL=09
trapoid	char(50)	YES		NULL=09
trapfull	char(50)	YES		NULL=09
target	char(50)	YES		NULL=09
enterprise	char(80)	YES		NULL=09
community	char(50)	YES		NULL=09
generictrap	char(80)	YES		NULL=09
specifictrap	char(80)	YES		NULL=09
version	char(10)	YES		NULL=09
severity	int(11)	YES		NULL=09
ack	int(11)	YES		NULL=09


what am i doing wrong ?
cheers G
*************************************************************************=
*******
This message has been Virus Scanned by old women and
that poor water boy Hando Jin :- Han Wong's son.
The Song "Hot Shot City" is particularly good


_____________________________________________________________________
This=20message=20has=20been=20checked=20for=20all=20known=20viruses=20by=20=
the=20
RMS=20Services=20Ltd=20Virus=20Scanning=20Service.=20For=20further=20infor=
mation=20visit
http://www.rms.co.uk.co.uk=20or=20call=20UK=2001454=20281265