Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql	13 Oct 2005 01:32:15 -0000	1.11
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql	13 Oct 2005 01:45:47 -0000	1.12
@@ -129,7 +129,14 @@
 -- calendars for the section
 
 create or replace view dlec_view_calendars as (
-select section_id, calendars.calendar_id from acs_objects, calendars, apm_packages, dotlrn_ecommerce_section, dotlrn_communities where dotlrn_ecommerce_section.community_id = dotlrn_communities.community_id and  acs_objects.context_id = dotlrn_communities.package_id and acs_objects.object_id = apm_packages.package_id and apm_packages.package_key='calendar' and calendars.package_id = apm_packages.package_id
+	select section_id, calendars.calendar_id 
+	from acs_objects, calendars, apm_packages, dotlrn_ecommerce_section, 
+	dotlrn_communities 
+	where dotlrn_ecommerce_section.community_id = dotlrn_communities.community_id 
+	and  acs_objects.context_id = dotlrn_communities.package_id 
+	and acs_objects.object_id = apm_packages.package_id 
+	and apm_packages.package_key='calendar' 
+	and calendars.package_id = apm_packages.package_id
 );
 
 create or replace view dlec_view_cal_session_item_types as (
