I'm not sure if anyone is watching this, but the problem seems to be related to the number of rows being returned. If I limit the number of rows by using Maxrows="200" it returns that many records.
Does anyone know if CFLDAP is knowing limited to the number of rows it can return? Thanks, Kevin > -----Original Message----- > From: Kevin Cundick [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 1:16 PM > To: CF-Talk > Subject: CFLDAP Problem > > > I have a LDAP database setup to authorize the login of > Vendor's to a web application we have setup. To manage the > Vendor's that have been setup in LDAP we have an > administration screen. When we list the Vendors we have two > ways to list them, by Company Name and by Vendor ID. > > Sorting by Company Name works great with no problem. The > problem starts when sorting by Vendor ID. Our Vendor numbers > are six digits. We list them according to the starting > digit. So if we need to find information on a Vendor Number > that is 123456, we list all of the vendors that start with 1. > The weird thing is that it brings up all the records great > for 1,3-9. The problem is if we try to list a Vendor with > 2xxxxx. We get an CFLDAP error. This is the code we use > (with a few changes to protect security)... > > <cfldap action="QUERY" > name="user" > > attributes="uid,fjaccountstatus,fjlastlogin,givenname,sn,o,mail" > start="ou=Tradepart,ou=Ext,o=FJ" > sort="ui,sn,given" > filter="(ui=#trim(attributes.vid)#*)" > sortcontrol="nocase" > server="200.100.200.34" > username="cn=EDI,ou=Admin,ou=Group,o=FJ" > password="xxxxxx"> > > If attributes.vid is 2 in this case we get this CFLDAP error... > > Error Occurred While Processing Request > Error Diagnostic Information > CFLDAP > > > The error occurred while processing an element with a general > identifier of (CFLDAP), occupying document position (60:2) to > (69:27) in the template file > /opt/apache/htdocs/flyingj/company/EDI/DSP/dsp_manager.cfm. > > > Which isn't very helpful. > > Anyone have any ideas what is happening here? > > Thanks for your time! > > Kevin Cundick > Webmaster > Flying J Inc > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
