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