These look like Windows Active Directory attributes. So, I will assume you are using AD and SQL 2000 on the same domain.
If so, you can use ADSI in a custom ActiveX task in a DTS package to pull the data from AD and insert it into SQL Server. It will be much faster than putting a web server between the two. If you would like to see some code, I'd be happy to post it. As far as this problem, I would start with outputting only a single attribute and running the page. If there are no errors, I would swap out another attribute and continue until I pinpointed the offending attribute. I would agree with you that these are simple-value attributes. These cannot hold binary information and I don't think any of these hold multi-values either. Although multi-values won't cause an error to be thrown. It could very well be another issue in unrelated code on the same page. M!ke -----Original Message----- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 2:41 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query CFDUMP returns all the records and everything looks goods. It displays all the data and puts [empty string] for nulls. These are the field names it returns: COMPANY EMPLOYEEID FACSIMILETELEPHONENUMBER GIVENNAME HOMEPHONE INITIALS L MAIL MOBILE OTHERTELEPHONE PAGER PHYSICALDELIVERYOFFICENAME SAMACCOUNTNAME SN ST TELEPHONENUMBER TITLE Nothing complex about any of these values. What do you suggest as other ideas for exporting LDAP data. CSVDE? Using SQL Server 2000. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207466 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
