Index: openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql	18 Jul 2003 02:47:33 -0000	1.2
+++ openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql	19 Jul 2003 01:48:45 -0000	1.3
@@ -8,7 +8,7 @@
             select cm.keyword_id,
                    ci.item_id,
                    cr.title,
-		   to_char(cr.publish_date, 'Mon DD, YYYY') as pretty_publish_date
+		   to_char(cr.publish_date, 'Mon FMDD, YYYY') as pretty_publish_date
             from cr_item_keyword_map cm,
                  cr_revisions cr,
                  cr_items ci
@@ -29,7 +29,7 @@
     
             select ci.item_id,
                    cr.title,
-		   to_char(cr.publish_date, 'Mon DD, YYYY') as pretty_publish_date
+		   to_char(cr.publish_date, 'Mon FMDD, YYYY') as pretty_publish_date
             from cr_revisions cr,
                  cr_items ci
             where ci.item_id not in (select item_id
@@ -43,5 +43,35 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="classified-ads::ads::get.select_widgets">
+        <querytext>
 
+            select cawv.*,
+                   aa.default_value,
+                   aa.attribute_name,
+                   aa.datatype
+            from acs_attributes aa,
+                 ca_attribute_widget_values cawv,
+                 ca_attributes ca
+            where aa.attribute_id = cawv.attribute_id and
+                  ca.attribute_id = aa.attribute_id and
+                  aa.object_type = :content_type and
+                  cawv.enabled_p = 't' and
+                  (ca.sitewide_p = 't' or
+                   ca.package_id = :package_id)
+            order by aa.sort_order asc
+
+        </querytext>
+    </fullquery>
+
+    <fullquery name="classified-ads::ads::get.select_data">
+        <querytext>
+
+            select *
+            from cr_ca_adsx
+            where revision_id = :revision_id
+
+        </querytext>
+    </fullquery>
+
 </queryset>