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. >1. As previously mentioned, cfdump the query and look for any non-string >(non-simple) values. Also, what are the ldap attributes you are >outputting when this errors? > >2. If you want to export data from ldap to a database, there may be a >better way. What is your ldap server and database server make and >model? > >M!ke > >-----Original Message----- >From: Scott Sylvester [mailto:[EMAIL PROTECTED] >Sent: Monday, May 23, 2005 1:06 PM >To: CF-Talk >Subject: RE: CFLDAP Dynimic Query > >hmm, the values I'm returning from the LDAP query are simple values. >When I use your code below, it lists out each field names I'm querying, >followed by the message that it's a complex query and needs special >handeling per the if statement for all 783 records. > >But, since I know the field names in this test case I use: > ><cfouput query="results"> > >#company# #st# #employeeID# > ></cfoutput> > >and it returns the values just fine for all 783 records. What I >ultimatley want to do is write all the values to .txt file seperated by >commas so I can import them into another table. I don't need the >records to be displayed on the screen at all. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207463 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
