SELECT login, unix_uid, shell, fullname, nickname, office_addr,
office_phone, home_phone, users_id, pop_id, potype, status
FROM users
- WHERE status = 1 or status = 5 or status = 6
+ WHERE status = 1 OR status = 2 OR status = 5 OR status = 6
ORDER BY users_id;
EXEC SQL OPEN u_cursor;
while (1)
EXEC SQL DECLARE u_cursor2 CURSOR FOR
SELECT users_id, login
FROM users
- WHERE status = 1
+ WHERE status = 1 OR status = 2
ORDER BY users_id;
EXEC SQL OPEN u_cursor2;
while (1)