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
+
+
-