Index: openacs-4/packages/photo-album/www/album-move.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/www/album-move.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/photo-album/www/album-move.xql 10 Jun 2003 10:07:11 -0000 1.1 +++ openacs-4/packages/photo-album/www/album-move.xql 12 Jun 2003 06:55:45 -0000 1.2 @@ -1,6 +1,16 @@ + + + select cr.title,cr.description,pa.story + from pa_albums pa, cr_items ci, cr_revisions cr + where ci.live_revision = cr.revision_id + and ci.live_revision = pa_album_id + and ci.item_id = :album_id + + + select parent_id from cr_items where item_id = :album_id