Thanks guys, this definitely helped me get this thing done. ~Steve http://lanctr.com/
-----Original Message----- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 4:15 AM To: CF-Talk Subject: Re: create variables from a string <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:304799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4