OpenACS

vinodk
committed
MAIN:vinodk:20020202034732
on 02 Feb 02
fixed ACS->OpenACS. regenerated html docs
/tcl/categories-procs-postgresql.xql (+22 -0)
80 80
81 81               select content_keyword__item_assign (:item_id,
82 82                                                    :keyword_id,
83 83                                                    null,
84 84                                                    null,
85 85                                                    null)
86 86
87 87         </querytext>
88 88     </fullquery>
89 89
90 90
91 91     <fullquery name="classified-ads::categories::item_unassign.delete_map">
92 92         <querytext>
93 93
94 94               select content_keyword__item_unassign (:item_id,
95 95                                                      :keyword_id)
96 96
97 97         </querytext>
98 98     </fullquery>
99 99
  100     <fullquery name="classified-ads::categories::get_custom_fields.get_fields">
  101         <querytext>
100 102            
  103             SELECT
  104                    attribute_name
  105               FROM
  106                    acs_attributes att,
  107                    ca_attribute_widget_values cawv,
  108                    (
  109                             select
  110                                    subtree.keyword_id
  111                               from cr_keywords parent, cr_keywords subtree
  112                              where parent.keyword_id = :keyword_id
  113                                and parent.tree_sortkey between subtree.tree_sortkey and tree_right(subtree.tree_sortkey)
  114                    ) keywords
  115             WHERE
  116                   att.attribute_id = cawv.attribute_id
  117               AND
  118                   cawv.keyword_id = keywords.keyword_id
  119                   
  120         </querytext>
  121     </fullquery>
  122
101 123 </queryset>