[Date Prev][Date Next] [Chronological] [Thread] [Top]

Subclassing inetOrgPerson

For our special situation I needed to have separate attributes for a given contacts multiple email addresses.  So I subclassed inetOrgPerson and added two new attributes, mail2 and mail3, identical to the mail attribute of inetOrgPerson.  If I do an ldapsearch like so

ldapsearch -x -b 'ou=people,dc=neotool,dc=com'  'mail=mike.stockemer@neotool.com'

The search is successfule and returns all attributes, even mail2 and mail3 for contacts who have this information.  If I do the same
search with email2 I get an error :80 unknown error.

Here is the query that is constructed:

Constructed query: SELECT DISTINCT ldap_entries.id,contact1.accountno,'neoToolPerson' AS objectClass,ldap_entries.dn AS dn FROM ldap_entries,contact1,contsupp WHERE contact1.accountno=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND upper(ldap_entries.dn) LIKE ? AND contsupp.rectype='P' and contsupp.contact='E-mail Address' and contact1.accountno = contsupp.accountno and contsupp.zip like '_0__' ORDER BY contsupref ASC AND (upper(TOP 1 contsupref)='MIKE.STOCKEMER@NEOTOOL.COM')
id: '1'
backsql_oc_get_candidates(): error executing query
Return code: -1
Native error code: 156
SQL engine state: 37000
Message: [OpenLink][ODBC][SQL Server]Incorrect syntax near the keyword 'AND'. (156)

Is my problem the ASC, where I am trying to order the results?


Mike Stockemer, Support Engineer