you can write the data, into a cfsavecontent variable
and then write that whole variables to a file, its
basically like a loop within a cfsavecontent, write
a whole lotta lines, then make one big file system
dump to a file, using #asc(10)##asc(13)# for your
line breaks, and commas to separate the values.
make sure to use cfsetting enablecfoutputonly
so that you dont get any unexpected spacing or
tabs or anything like that.
thats what i would do. if you are re-writing as
a csv.
later
tony
-----Original Message-----
From: brob [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 11:09 PM
To: CF-Talk
Subject: text files
Hey guys, i'm having coldfusion read data from a file (comma delimited
csv file), and reformat the data and put that in a new file for the user
to download. So far, it takes it about 50 seconds to write over 9000
rows worth of data (it's also doing some minor calculations for each
row). I was wondering if having SQL Server do that would be quicker.
Or if there's some other way to make it quicker. Thanks
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
