You might look into using RJustify, LJustify and CJustify inside a CFScript
block to put the information into one big variable and then use CFFile to
create your .csv file. Then link to it.
Just a thought.
Hatton Humphrey
> -----Original Message-----
> From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 11:26 AM
> To: CF-Talk
> Subject: creating excel file in the REQUESTED format
>
>
> Hi Folks,
> I have a query that pulls data on various items for about 72 counties,
> quarterly for the last five years. I'm creating a downloadable excel file,
> and the client has requested that the data be presented like so:
>
> INDICATOR COUNTYNAME1, COUNTYNAME2, COUNTYNAME3
> fs1 (date) value value
> value
> fs1 (anotherdate) value value
> value
>
> I think I must be braindead today, cause I can't figure out how
> in the heck
> I would get the data to layout like this without doing lots and lots of
> hardcoding. Here's the query that pulls all the data, if that's any help.
>
> <cfquery name="getfs" password="#pword#" username="#uname#"
> datasource="#dsn#">
> SELECT f.item, c.name AS county, d.total, d.datecollected
> FROM flpweb.cfs_foodstampdata d, flpweb.cfs_foodstamp f,
> flpweb.cfs_county c
> WHERE c.countyid = d.countyid
> AND d.foodstampid = f.foodstampid
> ORDER BY c.name, f.item, d.datecollected
> </cfquery>
>
>
>
> Deanna Schneider
> Interactive Media Developer
> [EMAIL PROTECTED]
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
