RE: [fw-general] Zend_Db & Enum to Options

2007-04-30 Thread Bill Karwin
UM, it's likely that you would be better off using a lookup table. Using a lookup table is also more portable to other RDBMS brands. Regards, Bill Karwin > -Original Message- > From: Ralph Schindler [mailto:[EMAIL PROTECTED] > Sent: Monday, April 30, 2007 9:57 AM > T

Re: [fw-general] Zend_Db & Enum to Options

2007-04-30 Thread Ralf Eggert
Hi Ralf, I extended Zend_Db_Table and added this little method. But I am afraid, this might only be working for MySQL. public function getOptions($column) { // build select to read column definition for selected column $sql = " SHOW COLUMNS "; $sql .= " FR

[fw-general] Zend_Db & Enum to Options

2007-04-30 Thread Ralph Schindler
Has anyone come up with a method for simply retrieving enum options from a table to use in a form's select drop down? Or would this be considered something that must be implemented as business logic? -ralph