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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists