I would like to see some code if you think it will be able to address the issue of the Active Directory fields being unkown and coming from a user input screen.
Thanks for your replys!! >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:207472 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
