-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I try using SQLObject (which, btw, ist great :-) on a legacy database.
The legazy table contains a column 'sysName' (in mixed case).
CREATE TABLE `Device` (
`device_id` bigint(20) unsigned NOT NULL auto_increment,
`sysName` varchar(20) default NULL,
PRIMARY KEY (`device_id`),
UNIQUE KEY `sysName` (`sysName`),
);
When defining
class Device(SQLObject):
class sqlmeta:
fromDatabase = 1
table = 'Device'
Device.sqlmeta.columns looks fine:
{'deviceID': <SOCol deviceID default=None not null>,
'sysName': <SOStringCol sysName default=None>}
But trying to access a row, yields an error:
"Unknown column 'Device.sys_name' in 'field list'"
How to fix this?
- --
Schönen Gruß - Regards
Hartmut Goebel
| Hartmut Goebel | IT-Security -- effizient |
| [EMAIL PROTECTED] | www.goebel-consult.de |
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org
iQEVAwUBQ/Bqk8zajR0mSa83AQJd9Qf+OoTPbQMG78k9s4aBLS8le1KsAKbHD9tK
kuq2ecuT8AzcdTXIKfQhnEzvrXD8b54sAwabxMfR5bcSbf+1Tfi3hvwDcshn3VdW
dR/lS7ixcPq2KPEVS/MHozhQC5DKYM6/RYvQwaKpyvQwAd45BEzsYRV2BdOiX1Jf
NQWUT9356VECtq56Tj7kI3MnK2ZiZj995ImAiZ3WPTPAh0R9qM8B8Ke7XNkiN5wd
cZR+QEI5FK3kf83UnajiQj9P3orrRQveN384tgUxe4VZmHa1QiunhEpFRKTCYv9A
UQSdziFR7kPlEJp2JXie99++8mZsyRcCHvRTwbTIYdqHfvkIGtOrYA==
=4j1/
-----END PGP SIGNATURE-----
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
