Thanks for the replys. When I use that code I get the following error message:
Complex object types cannot be converted to simple values.
The expression has requested a variable or an intermediate expression result as
a simple value, however, the result cannot be converted to a simple value.
Simple values are strings, numbers, boolean values, and date/time values.
Queries, arrays, and COM objects are examples of complex values.
The most likely cause of the error is that you are trying to use a complex
value as a simple one. For example, you might be trying to use a query variable
in a <CFIF> tag. This was possible in ColdFusion 2.0 but creates an error in
later versions.
The error occurred in I:\WEBDEV\SASDev\SISTest1\Query_AD.cfm: line 47
45 : <cfoutput query="results">
46 : <cfloop list="#results.columnList#" index="col">
47 : #results[col]#
48 : </cfloop>
49 : <br/>
> <cfoutput query="results#>
> <cfloop list="#results.columnList# index="col">
> #results[col]#
> </cfloop>
> <br/>
> <cfoutput>
>
> This will give you a basic dump of the results (If I typed everything
> correctly). More effort will be required if you care about the order
> or other formatting.
>
> --------------
> 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 10:10 AM
.....
> To: CF-Talk
.....
> Subject: RE: CFLDAP Dynimic Query
.....
>
.....
> I understand that #results.columnList# will give me the colmn Names
> from
.....
> the query, but how do I tell the <cfoutput> tag to ouput the data in
.....
> those columns?
.....
>
.....
> Thanks!
.....
>
.....
>
.....
> ><cfoutput>#results.columnList#</cfoutput>
.....
> >
.....
> >HTH
.....
> >
.....
> >--------------
.....
> >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 9:56 AM
.....
> >...To: CF-Talk
.....
> >...Subject: CFLDAP Dynimic Query
.....
> >...
.....
> >...I'm using the CFLDAP with the attributes parameter as a dynimic
.....
> variable
.....
> >...set by a user.
.....
> >...
.....
> >...<cfldap server="#LDAPserver#" action="query" name="results"
.....
> >...username="#LDAPuser#" password="#ldappass#" start="#ou_string#"
.....
> >...attributes="#at2#" delimiter=",">
.....
> >...
.....
> >...My problem is; how do I output this record set returned by the
> query
.....
> if I
.....
> >...don't know the column names of the query? Is there any way to
> ouput
.....
> this
.....
> >...record set directly to a text file?
.....
> >...
.....
> >...Any suggestions?
.....
> >...
.....
> >...Thanks!!!
.....
> >...
.....
> >...
.....
>
.....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:207441
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
