Index: openacs-4/packages/forums/www/moderate/move-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/move-oracle.xql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/forums/www/moderate/move-oracle.xql 8 Apr 2005 08:28:09 -0000 1.1 +++ openacs-4/packages/forums/www/moderate/move-oracle.xql 11 Apr 2005 10:38:59 -0000 1.1.2.1 @@ -18,8 +18,7 @@ select message_id, substr(tree_sortkey, 7, length(tree_sortkey)) as child_tree_sortkey from forums_messages - where forum_id = $message(forum_id) - and tree_sortkey between tree.left('$message(tree_sortkey)') and tree.right ('$message(tree_sortkey)') + where forum_id = $message(forum_id) and tree_sortkey between tree.left('$message(tree_sortkey)') and tree.right ('$message(tree_sortkey)') order by tree_sortkey desc @@ -41,6 +40,6 @@ set forum_id = :forum_id, tree_sortkey = '000000' where message_id = $message(message_id) - +