> I need a page that will take a query, and save the results to a text > file. > > What's more, the text file needs to be structured to a CSV format so > the data can easily be imported into a database. > > is this possible? Any hints on tags, or examples ???
What DB are you using? Usually, I try and spit this straight out of the db if possible, instead of using CF to handle it. If I'm using MySQL, I'll export the data as a csv using Navicat. Etc. etc.. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
