> ok, for some reason it doesn't come out grouped as I want
> it to!! anyone know why???
You don't need a GROUP attribute with your CFOUTPUT tag. Instead, you need
to add an "ORDER BY prod_type_id, name" clause to your SQL query.
The GROUP attribute allows you to build hierarchical data displays, so that
if you wanted to just show all products grouped by each product type ID, you
could output the prod_type_id field once, then have a nested CFOUTPUT to
display the products for that ID. If you wanted to do that, you'd still need
to ensure that your data was sorted properly in your SQL statement, using
ORDER BY to do this if necessary.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
