Index: openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql	20 Aug 2005 18:27:54 -0000	1.7
+++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql	29 Aug 2005 11:46:38 -0000	1.8
@@ -17,7 +17,7 @@
 
 	<fullquery name="get_courses">
 	<querytext>
-		select dc.course_id, dc.course_key, dc.course_name,
+		select dc.course_id, trim(dc.course_key) as course_key, dc.course_name,
 			dc.assessment_id, dec.section_id, dec.section_name,
 			dec.product_id, dec.community_id, dc.course_info,
 			ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p