Index: trunk/MagicSoft/Mars/datacenter/tools/resetdataset
===================================================================
--- trunk/MagicSoft/Mars/datacenter/tools/resetdataset	(revision 8517)
+++ trunk/MagicSoft/Mars/datacenter/tools/resetdataset	(revision 8520)
@@ -30,5 +30,5 @@
 
 datasetpath=/magic/datasets
-datasetpath=/test/bu.2006.10.05/datasets
+#datasetpath=/test/bu.2006.10.05/datasets
 
 function usage()
@@ -93,12 +93,12 @@
 
 
-alias mymysql='mysql -u $user --password=$ps --host=vela $db -s -e'
+alias mymysql='mysql -u $user --password=$pw --host=vela $db -s -e'
 
-whereclause1=" WHERE fDataSetNumer=$dataset"
+whereclause1=" WHERE fDataSetNumber=$dataset"
 statusreset=", fStartTime=NULL, fFailedTime=NULL, fFailedCode=NULL, fFailedCodeAdd=NULL, fReturnCode=NULL"
 query1="UPDATE DataSetProcessStatus SET fStarFilesAvail=NULL, fGanymed=NULL, fFillGanymed=NULL"
 query1=$query1$statusreset$whereclause1
 
-query2="DELETE FROM GANYMED "$whereclause1
+query2="DELETE FROM Ganymed "$whereclause1
 
 no=`printf %08d $dataset`
@@ -118,7 +118,12 @@
 echo " Found the following off sequences: $seqoff"
 
-whereclause2=" WHERE fSequenceFirst IN ($seqon,$seqoff)"
-query3="UPDATE SequenceProcessStatus SET fAllFilesAvail=NULL, fCallisto=NULL, fStar=NULL "
-query3=$query3$setstatusreseet$whereclause2
+if [ "$seqoff" = "" ]
+then
+   whereclause2=" WHERE fSequenceFirst IN ($seqon)"
+else
+   whereclause2=" WHERE fSequenceFirst IN ($seqon,$seqoff)"
+fi
+query3="UPDATE SequenceProcessStatus SET fCallisto=NULL, fStar=NULL "
+query3=$query3$statusreset$whereclause2
 
 query4="DELETE FROM Calibration"$whereclause2