Index: openacs-4/packages/survey/www/admin/question-delete.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/question-delete.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/survey/www/admin/question-delete.xql	16 Sep 2002 00:00:24 -0000	1.1
+++ openacs-4/packages/survey/www/admin/question-delete.xql	31 Oct 2002 13:42:42 -0000	1.2
@@ -41,10 +41,8 @@
 
 <fullquery name="survey_renumber_questions">
 <querytext>
-update survey_questions set sort_order=sort_order -1 
-where section_id in (
-	select section_id from surveys where 
-	survey_id=:survey_id)
+update survey_questions set sort_order=sort_order - 1 
+where section_id = :section_id
 and sort_order > :sort_order
 </querytext>
 </fullquery>