update acs_objects
set context_id = :new_package_id,package_id=:new_package_id
where object_id = :object_id
update acs_objects
set package_id = :new_package_id
where context_id = :object_id
SELECT package_id as new_package_id
FROM dotlrn_community_applets
WHERE community_id = :selected_community and applet_id = (select applet_id from dotlrn_applets where applet_key = 'dotlrn_faq')
UPDATE acs_objects
SET context_id = :trash_package_id,package_id=:trash_package_id
WHERE object_id = :object_id
UPDATE acs_objects
SET package_id = :trash_package_id
WHERE context_id = :object_id
SELECT b.object_id as package_id
FROM acs_objects as a,acs_objects as b
WHERE a.context_id=:selected_community and a.object_type='apm_package' and a.object_id=b.context_id and b.title='FAQ';
SELECT faq_name,separate_p
FROM faqs
WHERE faq_id=:object_id;
SELECT question,answer
FROM faq_q_and_as
WHERE faq_id=:object_id;
select faq__new_q_and_a (
:entry_id,
:faq_id,
:one_question,
:one_answer,
:sort_key,
'faq_q_and_a',
now(),
:user_id,
:creation_ip,
:faq_id
);
select faq__new_faq (:faq_id, :faq_name,:separate_p,'faq', now(), :user_id,:creation_ip,:package_id);