I need to generate a text file with CF. What I have is a
query result with the values from 3 columns, OrderID, VersionID and
Amount. I need to generate something like this:
0000123 | 002 | 1
0000124 | 002 | 2
0000125 | 002 | 5
0000126 | 002 | 1 and so on
I know I have to use <CFFILE action="write"
but I'm not sure how can I output my query result into this
1) You loop over the query and output it into a text variable
the text variable to the file. You can use string
build the variable OR the <cfsavecontent...> tag on the
flavors of CF.
2) You loop over the query and append the output to the file.
The choice between one and two is largely how is the file
created|updated? If it is done all at once then option one is
more performerent. If the file grows over time then option
two is the
way to go.