update forums_forums
set name= :name,
charter= :charter,
presentation_type= :presentation_type,
posting_policy= :posting_policy
where forum_id = :forum_id
update acs_objects
set title= :name
where object_id = :forum_id
select forum_id,
name,
posting_policy,
presentation_type
from forums_forums
where package_id = :package_id
order by name
select forums_forums.*
from forums_forums
where forums_forums.forum_id = :forum_id
update forums_forums
set enabled_p = 't'
where forum_id = :forum_id
update forums_forums
set enabled_p = 'f'
where forum_id = :forum_id
SELECT b.object_id as package_id
FROM acs_objects as a,acs_objects as b
WHERE a.context_id=:community_id and a.object_type='apm_package' and a.object_id=b.context_id and b.title='Forums';