Index: openacs-4/contrib/packages/classified-ads/www/admin/field-addedit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/www/admin/field-addedit.xql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/classified-ads/www/admin/field-addedit.xql 21 Jul 2003 16:08:07 -0000 1.2 +++ openacs-4/contrib/packages/classified-ads/www/admin/field-addedit.xql 29 Jul 2003 09:10:42 -0000 1.3 @@ -15,15 +15,25 @@ - select widget, label, html_options, select_options, validate, optional_p, enabled_p - from ca_attribute_widget_values - where attribute_id=:attribute_id + + select + widget, label, html_options, select_options, + validate, optional_p, enabled_p + from + ca_attribute_widget_values + where + attribute_id=:attribute_id + - select distinct datatype, datatype from acs_attributes order by datatype + + select distinct datatype, datatype + from acs_attributes + order by datatype + @@ -35,21 +45,44 @@ - select widget, widget from ca_attribute_widgets order by widget + + select widget, widget + from ca_attribute_widgets + order by widget + - update acs_attributes set pretty_name=:pretty_name, pretty_plural=:pretty_plural, sort_order=:sort_order, default_value=:default_value where attribute_id=:attribute_id + + update acs_attributes + set pretty_name = :pretty_name, + pretty_plural = :pretty_plural, + sort_order = :sort_order, + default_value = :default_value + where + attribute_id = :attribute_id + - update ca_attribute_widget_values set label=:label, html_options=:html_options, select_options=:select_options, validate=:validate, optional_p=:optional_p, enabled_p=:enabled_p where attribute_id=:attribute_id - + ` + update ca_attribute_widget_values + set label = :label, + html_options = :html_options, + select_options = :select_options, + keyword_id = :keyword_id, + extra_options = :extra_options, + validate = :validate, + optional_p = :optional_p, + enabled_p = :enabled_p + where + attribute_id = :attribute_id + + -