produce whole dn in SQL queries so we don't have to mungle it in code

[virtual-ldap] / sql / hreduperson.sql

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index b068bd7..cbf0811 100644 (file)
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -1,6 +1,6 @@
 
 select
-       concat('uid=',trim(userid))                     as dn,
+       concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr')        as dn,
        'person
        organizationalPerson
        inetOrgPerson