--- a/s4-funcs.sh	Fri Feb 19 15:36:51 2016 +0859
+++ b/s4-funcs.sh	Fri Feb 19 16:16:24 2016 +0859
@@ -430,17 +430,18 @@
 gecos() (
   u=`sqlquote ${1:-$user}`
   #gecos=`query "select val from user_s where name='$u' and key='gecos';"`
-  sql="select case when (select name from user where name=$u) is not null
-		then coalesce(
-		  (select val from user_s where name=$u and key='gecos'),
-		  $u)
-		when (select gname from grp where gname=$u) is not null
-		then coalesce(
-		  (select val from grp_s where gname=$u and key='gecos'),
-		  $u)
-		else $u
-		end;"
-  query "$sql"
+  # sql="select case when (select name from user where name=$u) is not null
+  # 		then coalesce(
+  # 		  (select val from user_s where name=$u and key='gecos'),
+  # 		  $u)
+  # 		when (select gname from grp where gname=$u) is not null
+  # 		then coalesce(
+  # 		  (select val from grp_s where gname=$u and key='gecos'),
+  # 		  $u)
+  # 		else $u
+  # 		end;"
+  #query "$sql"
+  query "select gecos from gecoses where name=$u;"
 )
 setpar() {
   query "replace into par values('$session', '$1', '$2', \"$3\");"