if (!*strtrim(path))
continue;
+ for (c = label; *c; c++)
+ *c = tolower(*c);
fprintf(out, "%s:%s\n", label, path);
EXEC SQL OPEN alias_cursor;
if (!*strtrim(alias))
continue;
+ for (c = alias; *c; c++)
+ *c = tolower(*c);
fprintf(out, "%s:%s\n", alias, path);
}
EXEC SQL CLOSE alias_cursor;
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;