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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists