Yeap, like I said this exact query works flawlessly when using ldapsearch.exe I just did not know if maybe there was another way(Java perhaps?) within CF to make an LDAP query that make be a work around for this. Although if the server slow downs were completely unrelated then might just stick with the no timeout attribute method and move on from that. The person who is working on this project just does not like the no timeout attribute approach for whatever reasons unique to them.
On Fri, 18 Mar 2005 16:38:50 -0600, Dawson, Michael <[EMAIL PROTECTED]> wrote: > Hmmm. Other than the timeout attribute, everything looks good. > > M!ke > > -----Original Message----- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Friday, March 18, 2005 4:36 PM > To: CF-Talk > Subject: Re: CFLDAP in CFMX (6.1 and 7.0) > > I think the server slow downs(mentioned in my other email) were actually > unrelated to my page, at least hoping since things magically spead up > this afternoon. This is interesting because nightly we have a process > that literally pulls out something like 55k records from LDAP and has no > issues, it does use the timeout attribute and is set to 2000. Now that > process is still on a CF5 server so maybe that is why it has not come up > with missing records. I'd have to pull up that file but pretty certain > it is actually 26 LDAP calls due to being inside a loop, it is nice and > ugly. > > Anyway, here is my test code that would not pull out all user groups > consistantly: > > <cfldap action="query" > name="qryGetGroups" > start="o=slb,c=an" > attributes="cn,objectclass" > filter="(&(objectclass=slbGroup)(uniquemember=cn=John > Smith 123456,ou=employee,o=SLB,c=AN))" > server="#Application.LDAPserver#" > port="#Application.LDAPport#" > timeout="200" > scope="subtree"> > > <cfoutput>Groups: #ListLen(ValueList(qryGetGroups.cn))#</cfoutput> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
