Index: openacs-4/packages/general-comments/www/view-comment.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/www/Attic/view-comment.xql,v diff -u -N --- openacs-4/packages/general-comments/www/view-comment.xql 24 Jan 2005 00:40:36 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,55 +0,0 @@ - - - - - - - select r.title, - r.mime_type, - i.name, - i.item_id - from cr_items i, - cr_revisions r - where i.parent_id = :comment_id and - r.revision_id = i.live_revision - - - - - - - - - select i.item_id, - e.label, - e.url - from cr_items i, cr_extlinks e - where i.parent_id = :comment_id and - e.extlink_id = i.item_id - - - - - - - - select object_id from general_comments where comment_id = :comment_id - - - - - - - - select r.revision_id, - o.creation_date as revision_date - from cr_revisions r, - acs_objects o - where r.item_id = :comment_id and - o.object_id = r.revision_id - order by o.creation_date desc - - - - -