Index: openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql	6 Apr 2007 15:52:23 -0000	1.1
+++ openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql	9 Apr 2007 21:16:04 -0000	1.2
@@ -7,7 +7,7 @@
 </fulluqery>
 
 <fullquery name="get_prev_sort_order">
-select sort_order from (select sort_order from ims_cp_items where parent_item=:parent_item and sort_order < : sort_order order by sort_order) s where s.rownum = 1
+select sort_order from (select sort_order from ims_cp_items where parent_item=:parent_item and sort_order < : sort_order order by sort_order desc) s where s.rownum = 1
 </fulluqery>
 
 </queryset>
\ No newline at end of file
Index: openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql	6 Apr 2007 15:52:23 -0000	1.1
+++ openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql	9 Apr 2007 21:16:04 -0000	1.2
@@ -10,7 +10,7 @@
 
 <fullquery name="get_prev_sort_order">
 <querytext>
-select sort_order from ims_cp_items where parent_item=:parent_item and sort_order < :sort_order order by sort_order limit 1
+select sort_order from ims_cp_items where parent_item=:parent_item and sort_order < :sort_order order by sort_order desc limit 1
 </querytext>
 </fullquery>