Index: openacs-4/packages/cms/www/modules/templates/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/templates/index.xql 8 Jun 2001 01:44:53 -0000 1.1
+++ openacs-4/packages/cms/www/modules/templates/index.xql 16 Nov 2004 22:32:51 -0000 1.2
@@ -5,7 +5,7 @@
- select content_type from cr_items where item_id = :id
+ select content_type from cr_items where item_id = :item_id
@@ -19,7 +19,7 @@
from
cr_folders f, cr_items i, acs_objects o
where
- i.item_id = (select parent_id from cr_items where item_id = :id)
+ i.item_id = (select parent_id from cr_items where item_id = :item_id)
and
i.item_id = f.folder_id
and
@@ -32,12 +32,12 @@
select
- f.folder_id, f.label, i.name,
+ f.folder_id, f.folder_id as item_id, i.name, f.label,
to_char(o.last_modified, 'MM/DD/YY HH:MI AM') as modified
from
cr_folders f, cr_items i, acs_objects o
where
- i.parent_id = :id
+ i.parent_id = :item_id
and
i.item_id = f.folder_id
and