My experience w/ option 2: don't do it. I made a tag myself that looped through
query.fieldnames and it was extremely slow. It worked fine with a few hundred
records, but getting into 1500 records pretty much rendered it useless, I got memory
errors and it took forever to process.
Even doing a simple loop with hard coded field names takes upwards of 60 seconds to
make a csv with 7000 records (about 20 fields of contact/membership information). The
execution time is acceptable for files with 1500 or so records in my case. If anyone
knows of a better way to make CSV, I am all ears... maybe a CFX tag would execute
faster. My instinct is to make a scheduled task to create all of the csv files I
might need (over 1000 files), but I am afraid that would take too long to execute too.
- Ben Morris
>>> Critter <[EMAIL PROTECTED]> 08/29/01 11:25AM >>>
Hello Deanna,
Option 1.
there is a tag in the gallery that will output to a csv file, it has some errors in
it, so those will need to be fixed....but other than that it works ok.
Option 2.
you could just loop thru the data, output the query.fieldnames, then loop thru the
recordset and build your file.....and push it with cfcontent if you want....
Option 1 - most of the work done for you......
Option 2 - opposite of option 1.
--
Critter, MMCP
Certified ColdFusion Developer
Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion">
-------------------------------------------
Wednesday, August 29, 2001, 11:26:12 AM, you wrote:
DS> Hi Folks,
DS> I have a query that pulls data on various items for about 72 counties,
DS> quarterly for the last five years. I'm creating a downloadable excel file,
DS> and the client has requested that the data be presented like so:
DS> INDICATOR COUNTYNAME1, COUNTYNAME2, COUNTYNAME3
DS> fs1 (date) value value
DS> value
DS> fs1 (anotherdate) value value
DS> value
DS> I think I must be braindead today, cause I can't figure out how in the heck
DS> I would get the data to layout like this without doing lots and lots of
DS> hardcoding. Here's the query that pulls all the data, if that's any help.
DS> <cfquery name="getfs" password="#pword#" username="#uname#"
datasource="#dsn#">>
DS> SELECT f.item, c.name AS county, d.total, d.datecollected
DS> FROM flpweb.cfs_foodstampdata d, flpweb.cfs_foodstamp f, flpweb.cfs_county c
DS> WHERE c.countyid = d.countyid
DS> AND d.foodstampid = f.foodstampid
DS> ORDER BY c.name, f.item, d.datecollected
DS> </cfquery>
DS> Deanna Schneider
DS> Interactive Media Developer
DS> [EMAIL PROTECTED]
DS>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
