First off I generally try to dissuade folks from using the SQL format for querying LDAP directories, it makes developers think capability exists that doesn't.
Second, mail attribute is not going to have any type of address other than SMTP. Third, an X500 address would be unusual, do you mean X400 address? Every mailbox has an X400 address by default, that will be maintained in proxyAddresses and textEncodedOrAddress (same value in both). The only default X500 address in Exchange would be what is used for the legacyExchangeDN which is not maintained in proxyAddresses. The only time you would have an X500 in proxyAddresses is if you manually added it (say you modified the LEDN and wanted to keep the old one around for routing, permissions, etc). joe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Benway Sent: Tuesday, May 30, 2006 2:59 PM To: [email protected] Subject: [ActiveDir] Query for user AD info from web application Our internet web application use AD to pull user information. They start with the users email address and then look up other information. We've notice today that if a user has a X500 address our query doesn't work. Here's what the web developer sent me SELECT displayName FROM 'GC://DOMAIN.COM' WHERE objectCategory='organizationalPerson' AND ((mail = '[EMAIL PROTECTED]')) I don't know why a X500 address would mess this up, ideas? Thanks,jb -------------------------- Jason Benway Network Services Manager [EMAIL PROTECTED] GHSP 1250 S.Beechtree Grand Haven, MI 49417 616-847-8474 Fax: 616-850-1208 List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ml/threads.aspx List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ml/threads.aspx
