这篇博客揭示了一个常见误解，即在使用LDAP时，不能像在关系型数据库中那样直接对结果集进行任意字段排序。作者通过代码示例说明，必须在请求的属性中包含用于排序的属性（如'sn'），否则排序不会生效。这提醒了读者， LDAP 的工作方式与RDBMS不同，需要特别注意其特性。
This note may be self-evident, but the functionality of ldap_sort threw off this sometime user of relational databases.
The following code will NOT do what you expect:
// attributes we want to retrieve from LDAP server$ldap_attributes= array ('cn','o','mail') ;// retrieve attributes from matching entries$search_results=ldap_search($ldap_conn,'dc=example,dc=org','(objectclass=*)',0,500,30) ;// sort entries by last name ('sn')ldap_sort($ldap_conn,$search_results,'sn') ;?>
The entries will NOT be sorted by last name. Why not? Because LDAP doesn't function like a RDBMS; you cannot sort a result set on an arbitrary field, regardless of whether you "selected" it. You must always include the attribute by which you want to sort your entries among the requested attributes (add 'sn' to $ldap_attributes, in this case).
Hope this is helpful to some other folks who scratched their heads when they tried to sort entries and it didn't work out...
1696
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
