Using ENUM column in table

Hi,

When I create a table with one column of type ENUM and then generate
scaffolding for the model and controller the ENUM column isn’t shown as
a drop down in the edit view. It just shows the column name and that’s
it. Am I missing something?

Here’s the SQL for the table:

drop table if exists products;
CREATE TABLE products (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
sku varchar(6) NOT NULL,
price decimal(10,2) not null,
state ENUM (‘kansas’,‘georgia’, ‘new york’) NOT NULL,
date_available datetime not null
) CHARSET=utf8;

Thanks,
Scott

Scott wrote:

Hi,

When I create a table with one column of type ENUM and then generate
scaffolding for the model and controller the ENUM column isn’t shown as
a drop down in the edit view. It just shows the column name and that’s
it. Am I missing something?

Here’s the SQL for the table:

drop table if exists products;
CREATE TABLE products (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
sku varchar(6) NOT NULL,
price decimal(10,2) not null,
state ENUM (‘kansas’,‘georgia’, ‘new york’) NOT NULL,
date_available datetime not null
) CHARSET=utf8;

Thanks,
Scott

Unfortunately, there is no support for enums currently.
Refer to this thread:
http://lists.rubyonrails.org/pipermail/rails/2005-January/001536.html