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

Reply via email to