get proper version of name

diff --git a/gen/letter.dc b/gen/letter.dc
index 4e6d14e80f9060e35b176bc02335ba3e0705d31c..19a6344d358f033b88f99773bb7d3d0fb31af009 100644 (file)
--- a/gen/letter.dc
+++ b/gen/letter.dc
@@ -35,7 +35,7 @@ char **argv;
     int flag;
     struct timeval tv;
     EXEC SQL BEGIN DECLARE SECTION;
-    char login[10], fullname[34], addr[84];
+    char login[10], first[17], last[17], fullname[34], addr[84];
     int lastrun, when;
     EXEC SQL END DECLARE SECTION;
 
@@ -78,14 +78,16 @@ char **argv;
     gettimeofday(&tv, NULL);
 
     EXEC SQL DECLARE x CURSOR FOR SELECT 
-      login, fullname, xaddress, secure
+      login, first, last, xaddress, secure
        FROM users WHERE secure > :lastrun;
     EXEC SQL OPEN x;
     while (1) {
-       EXEC SQL FETCH x INTO :login, :fullname, :addr, :when;
+       EXEC SQL FETCH x INTO :login, :first, :last, :addr, :when;
        if (sqlca.sqlcode != 0) break;
        strtrim(login);
-       strtrim(fullname);
+       strtrim(first);
+       strtrim(last);
+       sprintf(fullname, "%s %s", first, last);
        print_letter(out, login, fullname, strtrim(addr), when);
     }