OH! now I remember. man i haven't used it for so long heh >From: Dave Watts <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Group Query I going Crazy!!! >Date: Thu, 20 Sep 2001 17:13:50 -0400 > > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
