You *should* be getting 24 rows - that is how joining works!
To make your grouped output work, start by adding "ORDER BY gp_name" to the end
of the query.
Then this CF code should do what you want...
<cfoutput query="thababove" group="gp_name">
[group logic] #gp_name#
<cfoutput>
[individual logic] #gp_image_name#
</cfoutput>
</cfoutput>
Also, use sql table aliases in your query to make it more readable.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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-talk/message.cfm/messageid:320210
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
