Changeset 9088 for trunk/MagicSoft/Mars/datacenter

Timestamp:

08/05/08 09:44:03 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter

Files:

• scripts/makecallistolinks (modified) (1 diff)
• scripts/sourcefile (modified) (2 diffs)
• tools/resetpriorities (added)

trunk/MagicSoft/Mars/datacenter/scripts/makecallistolinks

@@ -54 +54 @@
 query="SELECT fSequenceFirst, fTelescopeNumber from SequenceProcessStatus where fReturnCode=13 and fProgramId=14"
 primaries=( `sendquery` )
-echo ${primaries[@]}
 if [ ${#primaries[@]} -eq 0 ]
 then 

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -281 +281 @@
    query=$query" and isnull(fStartTime) and isnull(fFailedTime) and isnull(fProgramId) and isnull(fReturnCode) "
    query=$query" order by fPriority desc "
-   if [ "$@" != "" ]
+   if [ "$@ " != " " ]
    then 
       query=$query" limit 0, $@ "
@@ -367 +367 @@
       if [ $i -lt `expr ${#prims[@]} - 1` ]
       then 
-         query=$query" ${prims[$i]}=${primaries[$s+$s+$i]} and "
+         query=$query" ${prims[$i]}='${primaries[$s+$s+$i]}' and "
       else
-         query=$query" ${prims[$i]}=${primaries[$s+$s+$i]} "
+         query=$query" ${prims[$i]}='${primaries[$s+$s+$i]}' "
       fi
    done