[1949] in Moira
DCM tweaks
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Tue Apr 2 05:55:57 2002
Message-Id: <200204021055.FAA16614@hodge-podge.mit.edu>
To: moiradev@MIT.EDU
Date: Tue, 02 Apr 2002 05:55:55 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>
Since the loose analogy of status 1 ~ status 9 holds, both of
these DCMs should know about status 9 users.
Index: warehouse.pc
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/gen/warehouse.pc,v
retrieving revision 1.11
diff -u -r1.11 warehouse.pc
--- warehouse.pc 2000/11/30 23:27:49 1.11
+++ warehouse.pc 2002/04/02 10:54:27
@@ -96,7 +96,7 @@
SELECT login, clearid, first, last, middle
FROM users
WHERE (status = 1 or status = 2 or status = 5 OR
- status = 6 or status = 7);
+ status = 6 or status = 7 or status = 9);
EXEC SQL OPEN x;
while (1)
{
Index: www.pc
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/gen/www.pc,v
retrieving revision 1.7
diff -u -r1.7 www.pc
--- www.pc 2001/09/14 23:17:50 1.7
+++ www.pc 2002/03/31 14:54:06
@@ -234,7 +234,7 @@
EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
EXEC SQL DECLARE user_cursor CURSOR FOR
- SELECT login FROM users WHERE status=1 OR status=2 OR status=6
+ SELECT login FROM users WHERE status=1 OR status=2 OR status=6 OR status=9
ORDER by login;
EXEC SQL OPEN user_cursor;
