Index: openacs-4/packages/dotlrn-ecommerce/www/home.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/home.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn-ecommerce/www/home.tcl	28 Jul 2005 23:43:43 -0000	1.4
+++ openacs-4/packages/dotlrn-ecommerce/www/home.tcl	4 Aug 2005 23:33:17 -0000	1.5
@@ -86,11 +86,15 @@
 set invisible_p [whos_online::user_invisible_p [ad_conn untrusted_user_id]]
 
 db_multirow -extend { order_url } orders get_orders {
-    select order_id, confirmed_date
-    from ec_orders
-    where user_id=:user_id
+    select o.order_id, confirmed_date
+    from ec_orders o, dotlrn_ecommerce_transactions t, ec_items i, dotlrn_ecommerce_section s
+    where o.order_id = t.order_id
+    and o.order_id = i.order_id
+    and i.product_id = s.product_id
+    and user_id=:user_id
     and order_state not in ('in_basket','void','expired')
-    order by order_id
+    group by o.order_id, confirmed_date
+    order by o.order_id
 } {
     set order_url [export_vars -base [apm_package_url_from_key ecommerce]order { order_id }]
     set confirmed_date [util_AnsiDatetoPrettyDate $confirmed_date]