smith2009
03-26-2009, 09:23 AM
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 ??
:confused:
___________________________
Smith
<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 ??
:confused:
___________________________
Smith