Need to include clearid in the select statement.

diff --git a/gen/ldap.gen b/gen/ldap.gen
index 1da68704de91364dc78d177841e4ff6e2460730c..1146e17e7690dcffbbfd7d0ea16f0e42bc7031b2 100755 (executable)
--- a/gen/ldap.gen
+++ b/gen/ldap.gen
@@ -18,7 +18,7 @@ umask 022;
 $dbh = DBI->connect("dbi:Oracle:moira", "moira", "moira")
     || exit $MR_DBMS_ERR;
 
-$sth = $dbh->prepare("SELECT login, first, middle, last FROM users " .
+$sth = $dbh->prepare("SELECT login, first, middle, last, clearid FROM users " .
                     "WHERE status = 1");
 
 $sth->execute;