I'll give it a try, although I'm not too confident about the results. The
table structures are so different and where the new table allows for easy
looping I just don't think the old table will let me loop. It has one row of
data per city, with something like 20-30 columns for each category. So I need
to output the value of column 1 in line 1, column 2 in line 2 etc. I'm
wondering if it's worth it to try and get our data center to recreate the
original table for me. Here are both queries so you can see what I mean:
<Cfquery Name="rstPopAge">
SELECT a.age_tot as agetot_00, a.age01 as age01_00, a.age02 as
age02_00, a.age03 as age03_00, a.age04 as age04_00, a.age05 as age05_00,
a.age06 as age06_00, a.age07 as age07_00, a.age08 as age08_00, a.age09 as
age09_00, a.age10 as age10_00, a.age11 as age11_00, a.age12 as age12_00,
a.age13 as age13_00, a.age14 as age14_00, a.age15 as age15_00, a.age16 as
age16_00, a.age17 as age17_00, a.age18 as age18_00, a.age19 as age19_00
FROM CENSUS_SF1_00
WHERE semmcd = #local_semmcd#
</Cfquery>
<cfquery name="SemPopAge">
SELECT pop2035, category
FROM rdf_dba.rdf2035_pop_agegroup
WHERE semmcd = #local_semmcd#
ORDER BY category
</cfquery>
>You might be better off looking to create one query that holds all the
>needed data. Then, and it sounds like this is the way to go from your
>explanation, look at using the group attribute of cfoutput when looping over
>your query.
>
>Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4240
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
