CF Loop in CF File

[smith2009]

As you can see the code executes and creates scrollerData.txt with "Caption is:"the caption in the database", but it only creates the first record it finds. I have tried several implementations of cfloop to try to get it to create all the captions.


<cfquery name="feed" datasource="rss">
SELECT caption,link,active
FROM feeds
WHERE active = 1
</cfquery>


<cfoutput>

<cffile action="write"
file="#currentPath#scroller/scrollerData.txt"
output="Caption is:#feed.caption#">

</cfoutput>
How Can I fix this ??



___________________________
Smith