Index: openacs-4/packages/static-portlet/tcl/static-portal-content-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/tcl/static-portal-content-procs.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/static-portlet/tcl/static-portal-content-procs.xql 21 Jul 2002 20:06:07 -0000 1.1 +++ openacs-4/packages/static-portlet/tcl/static-portal-content-procs.xql 23 Jul 2002 13:40:45 -0000 1.2 @@ -2,48 +2,47 @@ - - + + select pem.element_id as element_id from portal_element_map pem, portal_pages pp - where pp.portal_id= :portal_id + where pp.portal_id= :portal_id and pp.page_id = pem.page_id and pem.datasource_id= :ds_id - - + + - - - select value - from portal_element_parameters - where element_id = :element_id - and key = 'content_id' - - + + + select value + from portal_element_parameters + where element_id = :element_id + and key = 'content_id' + + - - - update static_portal_content set - content = :content, pretty_name = :pretty_name + + + update static_portal_content set + content = :content, pretty_name = :pretty_name where content_id = :content_id - - + + - - + + select pretty_name - from static_portal_content + from static_portal_content where content_id = :content_id - - + + - - + + select package_id - from static_portal_content + from static_portal_content where content_id = :content_id - - + + -