Index: openacs-4/packages/dotlrn/tcl/community-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs.xql,v
diff -u -r1.25 -r1.26
--- openacs-4/packages/dotlrn/tcl/community-procs.xql 11 Feb 2002 22:25:01 -0000 1.25
+++ openacs-4/packages/dotlrn/tcl/community-procs.xql 12 Feb 2002 19:08:08 -0000 1.26
@@ -264,42 +264,45 @@
-
-
- select impl_name
- from acs_sc_impls, acs_sc_bindings, acs_sc_contracts, dotlrn_applets
- where acs_sc_impls.impl_id = acs_sc_bindings.impl_id
- and acs_sc_impls.impl_name = dotlrn_applets.applet_key
- and acs_sc_contracts.contract_id = acs_sc_bindings.contract_id
- and acs_sc_contracts.contract_name = 'dotlrn_applet'
-
-
+
+
+ select impl_name
+ from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
+ where acs_sc_impls.impl_id = acs_sc_bindings.impl_id
+ and acs_sc_contracts.contract_id = acs_sc_bindings.contract_id
+ and acs_sc_contracts.contract_name = 'dotlrn_applet'
+
+
-
-
-select applet_key
-from dotlrn_community_applets dca, dotlrn_applets da
-where community_id= :community_id
-and dca.applet_id = da.applet_id
-
-
+
+
+ select applet_key
+ from dotlrn_community_applets dca,
+ dotlrn_applets da
+ where community_id = :community_id
+ and dca.applet_id = da.applet_id
+
+
-
-
-select applet_key from dotlrn_applets where status = 'active'
-
-
+
+
+ select applet_key
+ from dotlrn_applets
+ where status = 'active'
+
+
-
-
-select applet_key
-from dotlrn_community_applets dca, dotlrn_applets da
-where community_id= :community_id
-and active_p = 't'
-and dca.applet_id = da.applet_id
-and status = 'active'
-
-
+
+
+ select applet_key
+ from dotlrn_community_applets dca,
+ dotlrn_applets da
+ where community_id = :community_id
+ and active_p = 't'
+ and dca.applet_id = da.applet_id
+ and status = 'active'
+
+