postgresql7.1 select general_comment__new ( :comment_id, :object_id, :package_id, :parent_id, :context_id, :title, :description, :content, :user_id, now(), :creation_ip, :comment_mime_type, :is_live ) select content_item__get_latest_revision(:comment_id) as revision_id update cr_revisions set content = :content where revision_id = :revision_id select g.comment_id, r.title, r.mime_type, o.creation_user, u.full_name as author, to_char(o.creation_date, 'MM-DD-YYYY') as pretty_date, to_char(o.creation_date, 'Month DD, YYYY HH12:MI PM') as pretty_date2 $content_select from general_comments g, cr_revisions r, acs_objects o, cc_users u, cr_items i where g.object_id = :object_id and r.revision_id = i.live_revision and o.object_id = g.comment_id order by o.creation_date select site_node__url(s.node_id) as package_url from site_nodes s, apm_packages a where s.object_id = a.package_id and lower(a.package_key) = 'general-comments' LIMIT 1 select site_node__url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = 'general-comments' select g.comment_id, r.title, r.content, r.mime_type, o.creation_user, to_char(o.creation_date, 'MM-DD-YYYY') as creation_date, p.first_names || ' ' || p.last_name as author from general_comments g, cr_items i, cr_revisions r, acs_objects o, persons p where g.object_id = :object_id and i.item_id = g.comment_id and r.revision_id = i.live_revision and o.object_id = g.comment_id and p.person_id = o.creation_user order by creation_date select site_node__url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = 'general-comments'