Index: openacs-4/packages/lorsm/templates/lorsm-default.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/templates/lorsm-default.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lorsm/templates/lorsm-default.xql 12 Dec 2008 14:25:34 -0000 1.2 +++ openacs-4/packages/lorsm/templates/lorsm-default.xql 16 Feb 2009 16:44:43 -0000 1.3 @@ -1,7 +1,7 @@ - + select man_id from ims_cp_items i, ims_cp_organizations o @@ -10,23 +10,23 @@ - + select folder_id from ims_cp_manifests where man_id = :man_id - + select item_title, parent_item from ims_cp_items where ims_item_id = :imsitem_id - + select ims_cp_items.ims_item_id as child_item_id, ims_cp_items.item_title as child_title @@ -37,23 +37,23 @@ - + select count(*) from ims_cp_items where parent_item = :extracted_sql_children - + select count(*) from ims_cp_items where parent_item = :parent_item - + select ims_cp_items.parent_item as grandparent_item, ims_cp_resources.href as grandparent_href @@ -64,7 +64,7 @@ - + select href as parent_href from ims_cp_resources r, ims_cp_items_to_resources ir