From: mar <mar>
Date: Wed, 30 Dec 1992 16:33:14 +0000 (+0000)
Subject: need ascii numbers, not binary integers
X-Git-Tag: release77~282
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/a112f91ea014b2cd8f04114ec015f46dfc4ed04d?hp=5c91cb6105c0b0e0482fe4c7a345a2a2214d9282

need ascii numbers, not binary integers
---

diff --git a/server/cache.dc b/server/cache.dc
index e1b66a2c..ae04014b 100644
--- a/server/cache.dc
+++ b/server/cache.dc
@@ -235,27 +235,27 @@ char **name;
     switch (*type) {
     case 'U':
     case 'u':
-	EXEC SQL SELECT login INTO :iname FROM users WHERE users_id=:j;
+	EXEC SQL SELECT CHAR(login) INTO :iname FROM users WHERE users_id=:j;
 	break;
     case 'L':
     case 'l':
-	EXEC SQL SELECT name INTO :iname FROM list WHERE list_id=:j;
+	EXEC SQL SELECT CHAR(name) INTO :iname FROM list WHERE list_id=:j;
 	break;
     case 'M':
     case 'm':
-	EXEC SQL SELECT name INTO :iname FROM machine WHERE mach_id=:j;
+	EXEC SQL SELECT CHAR(name) INTO :iname FROM machine WHERE mach_id=:j;
 	break;
     case 'C':
     case 'c':
-	EXEC SQL SELECT name INTO :iname FROM cluster WHERE clu_id=:j;
+	EXEC SQL SELECT CHAR(name) INTO :iname FROM cluster WHERE clu_id=:j;
 	break;
     case 'F':
     case 'f':
-	EXEC SQL SELECT label INTO :iname FROM filesys WHERE filsys_id=:j;
+	EXEC SQL SELECT CHAR(label) INTO :iname FROM filesys WHERE filsys_id=:j;
 	break;
     case 'S':
     case 's':
-	EXEC SQL SELECT string INTO :iname FROM strings WHERE string_id=:j;
+	EXEC SQL SELECT CHAR(string) INTO :iname FROM strings WHERE string_id=:j;
 	break;
     default:
 	return(MR_INTERNAL);