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 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
