Index: openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql 7 Jun 2006 14:05:45 -0000 1.2 +++ openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql 12 Dec 2008 14:25:40 -0000 1.3 @@ -1,27 +1,27 @@ - postgresql7.1 + postgresql7.1 - - + + + select content_template__get_root_folder() + + - select content_template__get_root_folder() + + + select content_item__get_id(:url, :content_root, 'f') as item_id + + - - + + + select i.ims_item_id as imsitem_id + from ims_cp_items_to_resources i, ims_cp_files f + where f.file_id=:file_id + and i.res_id=f.res_id; + + - - - select content_item__get_id(:url, :content_root, 'f') as item_id - - - - - - select i.ims_item_id as imsitem_id from ims_cp_items_to_resources i, ims_cp_files f where f.file_id=:file_id and i.res_id=f.res_id; - - - -