<cfquery datasource="#application.ds#" name="pull_data">
SELECT *
FROM #URL.TABLE#
</cfquery>
<cfset yopath = "#application.masterpath#/#dateFormat(now(),
"yyyy_mm_dd")#_#URL.TABLE#.csv">
<cffile action="WRITE" file="#yopath#" output="#pull_data.columnList#"
addnewline="yes">
<cfloop query="pull_data">
<cfset dataRow = "">
<cfloop list="#pull_data.columnList#" index="col">
<cfset dataRow = ListAppend(dataRow,
pull_data[col][pull_data.currentrow])>
</cfloop>
<cffile action="APPEND" file="#yopath#" output="#dataRow#"
addnewline="yes">
</cfloop>
Should do ya, HTH
Dominic
--
Blog it up: http://fusion.dominicwatson.co.uk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304780
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
