On Thursday 08 June 2006 13:49, Ed Leafe wrote: > On Jun 8, 2006, at 10:38 AM, Henning Hraban Ramm wrote: > > - how can I cope with MySQL enum or set fields > > That's a MySQL-specific problem; most databases don't offer the > equivalent data type. You'd probably have to get a cursor object from > the bizobj's connection, and manually get the enum/set values by > writing custom SQL to query the database. Right now there really > isn't any good way to do this. > > What is more common, though, is that there is a good business rule > for limiting the acceptable values, and the database designer uses > that logic to determine that a certain field should only allow > certain values. You could add that logic to the business object and > only allow valid field values. How that would be done depends a lot > on the specifics of the enum/set values. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com
soon http://www.python.org/dev/peps/pep-0354/ John _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
