Rails - Aug 2006 - 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

-- 
Posted via http://www.ruby-forum.com/.

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

-- 
Posted via http://www.ruby-forum.com/.