Hi All,
I'm in the process of creating a VB class that access an Active Directory server for personnel data. I can get all personnel data just fine using LDAP dialect. The problem I'm having is returning a unique list of departments to place in a drop-down list (used in an advanced search). For starters, don't think there is a way to select distinct fields within an LDAP query. Secondly, I need to use SQL dialect to order the results - want departments in alphabetical order - unless there is a way to order results returned through LDAP dialect. And finally, I'm not sure how to implement SQL dialect queries within VB. Any direction, suggestions, and or solutions would be greatly appreciated.
Thanks,
Bob
I'm in the process of creating a VB class that access an Active Directory server for personnel data. I can get all personnel data just fine using LDAP dialect. The problem I'm having is returning a unique list of departments to place in a drop-down list (used in an advanced search). For starters, don't think there is a way to select distinct fields within an LDAP query. Secondly, I need to use SQL dialect to order the results - want departments in alphabetical order - unless there is a way to order results returned through LDAP dialect. And finally, I'm not sure how to implement SQL dialect queries within VB. Any direction, suggestions, and or solutions would be greatly appreciated.
Thanks,
Bob
