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 -N -r1.3 -r1.4
--- openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql	12 Dec 2008 14:25:36 -0000	1.3
+++ openacs-4/packages/lorsm/www/admin/reorder-items-oracle.xql	30 Nov 2010 13:14:20 -0000	1.4
@@ -1,25 +1,29 @@
 <?xml version="1.0"?>
 <queryset>
     <rdbms><type>oracle</type><version>8.1.7</version></rdbms>
-
     <fullquery name="get_next_sort_order">
+      <querytext>
         select sort_order
         from (select sort_order
                 from ims_cp_items
                 where parent_item=:parent_item
-                    and sort_order > : sort_order
+                    and sort_order > :sort_order
                     order by sort_order) s
         where s.rownum = 1
-    </fulluqery>
+      </querytext>
+    </fullquery>
 
     <fullquery name="get_prev_sort_order">
+      <querytext>
         select sort_order
         from (select sort_order
                 from ims_cp_items
                 where parent_item=:parent_item
-                    and sort_order < : sort_order
+                    and sort_order < :sort_order
                     order by sort_order desc) s
+
         where s.rownum = 1
+      </querytext>
     </fullquery>
 
 </queryset>