Index: openacs-4/packages/lorsm/www/admin/item-add-edit.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/item-add-edit.xql,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/lorsm/www/admin/item-add-edit.xql 8 Oct 2008 13:01:06 -0000 1.4 +++ openacs-4/packages/lorsm/www/admin/item-add-edit.xql 12 Dec 2008 14:25:35 -0000 1.5 @@ -1,46 +1,55 @@ - - - select item_title - from ims_cp_items - where ims_item_id=(select live_revision from cr_items - where item_id=:item_id) - - + + + select item_title + from ims_cp_items + where ims_item_id=(select live_revision + from cr_items + where item_id=:item_id) + + - - - select org_id from ims_cp_organizations where man_id=:man_id - - + + + select org_id + from ims_cp_organizations + where man_id=:man_id + + - - - select parent_id from cr_items where latest_revision=:org_id - - + + + select parent_id + from cr_items + where latest_revision=:org_id + + - - - update ims_cp_items - set sort_order = (select coalesce(max(sort_order),0) +1 - from ims_cp_items where org_id=:org_id) - where ims_item_id = :ims_item_id - - + + + update ims_cp_items + set sort_order = (select coalesce(max(sort_order),0) +1 + from ims_cp_items where org_id=:org_id) + where ims_item_id = :ims_item_id + + - - - select storage_type from cr_items where item_id=:item_id - - + + + select storage_type + from cr_items + where item_id=:item_id + + - - - update ims_cp_items set item_title=:title where ims_item_id=:ims_item_id - - + + + update ims_cp_items + set item_title=:title + where ims_item_id=:ims_item_id + +