added ordering 'show'
authorJiri Kuthan <jiri@iptel.org>
Mon, 15 Jul 2002 11:08:43 +0000 (11:08 +0000)
committerJiri Kuthan <jiri@iptel.org>
Mon, 15 Jul 2002 11:08:43 +0000 (11:08 +0000)
scripts/sc

index fa04a02..24a827f 100755 (executable)
@@ -414,7 +414,7 @@ case $1 in
                        $USRLOC.$USER_COLUMN='$1' order by expires desc"
                QUERY3="select $USRLOC.$USER_COLUMN, $TABLE.$EMAIL_COLUMN, $USRLOC.$CALLID_COLUMN \
                        from $TABLE, $USRLOC where  \
-                       $TABLE.$SUBSCRIBER_COLUMN=$USRLOC.$USER_COLUMN" 
+                       $TABLE.$SUBSCRIBER_COLUMN=$USRLOC.$USER_COLUMN  order by $USRLOC.$USER_COLUMN
 
                if [ $# -eq 1 ] ; then
                        sql_ro_query "$QUERY1"