Thanks. Randy
--- Ian Skinner <[EMAIL PROTECTED]> wrote: > Sorry, forgot the row part of the array notation. > > This is tested and should work, change query name > "Entity" as appropriate. > > <cfoutput query="Entity"> > <cfloop list="#entity.columnList#" index="col"> > <cfif > isSimpleValue(entity[col][entity.currentRow])> > <strong>#col#</strong> > #entity[col][entity.currentRow]#<br/> > <cfelse> > #col# is not a simple value.<br/> > </cfif> > </cfloop> > </cfoutput> > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > ....-----Original Message----- > ....From: Scott Sylvester > [mailto:[EMAIL PROTECTED] > ....Sent: Monday, May 23, 2005 11:06 AM > ....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:207468 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
