What are you trying to do? Yes, you can loop through your results and store them in a variable and comma-delimit them:
<cfoutput query="myQuery">
<cfset myVariable = "#myVariable##col1#,#col2#,#col3##chr(10)##chr(13)#">
</cfoutput>
And then store this variable to a text file using CFFILE, but is that what you're looking for?
>I'm trying to create an excel or a comma delimited file of a report that is
>based on a query that joins several tables. Using nested cfoutput is easy
>to get the results I want on a web page. What I'm wondering is if there is
>a way to put similar de-duped results into a variable. The same type of
>results that cfoutput generates without having to implement a lot of logic
>inside a cfloop to check when records values change in a way to eliminate
>the duplicates?
>
>Any help is appreciated
>
>Fernando Gomez
>Web Developer
>FIND/SVP, Inc.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
