Skip to main content
C
Calrain
Participant
December 9, 2009
Question

cfldap doesn't support pagesize

  • December 9, 2009
  • 1 reply
  • 850 views

cfdlap doesn't support the concept of data coming from an LDAP server in 'pages'.

With Active Directory, the default pagesize is 1000.

Can a...

pagesize="1000"

...attribute be added to the cfldap command so that when it sees 1000 entries returned, it will then ask for the next page of entries, and continue doing that until it retrieves all values from the LDAP servers?

This limit makes cfldap unusable in my environment, as I have more than 1000 entries returned from queries, and groups with more than 1000 members.

Can this be put on the 'wish list' for CF 10?

Thanks,

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    December 9, 2009

    I had a similar issue for an ad hoc query request once.  I forget the details but I remember the 1000 record issue.  The way I handled it was to loop through the letters of the alphabet and get 26 datasets.  Then I did a union q of q and took it from there.  This approach might work for whatever you are doing.

    C
    CalrainAuthor
    Participant
    December 9, 2009

    Yes, I've thought of doing that, but that is helpful when you are querying objects by name.  I'm querying by other attributes...

    I can do dodgy query joins, I just wish that Adobe could fix cfldap to work properly.

    Other LDAP connectors do it, you just put in pagesize=1000 and viola... the ldap engine starts dealing with pages and gets all the data.

    It makes it hard when you have groups with 30k members... and you want to retrieve the member attribute.

    I'll have to stop using cfldap, and write .NET web services which can be called by ColdFusion.  That way the full queries can be returned as cfldap won't be used at all.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices