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
