Index: openacs-4/packages/acs-subsite/www/admin/attributes/enum-add-2.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/attributes/enum-add-2.tcl,v diff -u -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/acs-subsite/www/admin/attributes/enum-add-2.tcl 10 Sep 2015 08:21:39 -0000 1.4.2.1 +++ openacs-4/packages/acs-subsite/www/admin/attributes/enum-add-2.tcl 28 Oct 2015 09:38:35 -0000 1.4.2.2 @@ -42,16 +42,7 @@ if { [db_resultrows] == 0 } { # No update - insert the row. Set the enum_value to # the pretty_name - db_dml insert_enum_value { - insert into acs_enum_values v - (attribute_id, sort_order, enum_value, pretty_name) - select :attribute_id, :sort_order, :pretty_name, :pretty_name - from dual - where not exists (select 1 - from acs_enum_values v2 - where v2.pretty_name = :pretty_name - and v2.attribute_id = :attribute_id) - } + db_dml insert_enum_value {} } } }