Because I want to use grouping, as I will be grouping by different things
other than Id's later on
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Group Query I going Crazy!!!
>Date: Thu, 20 Sep 2001 17:03:44 -0400
>
>how about order by?
>
>JoAnn A. Schlosser
>Senior Consultant
>Association Management Software
>Grant Thornton LLP
>Washington, D. C.
>703.837.4428
>
>
>
>-----Original Message-----
>From: Koo Pai Lao [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, September 20, 2001 4:59 PM
>To: CF-Talk
>Subject: Group Query I going Crazy!!!
>
>
>ok, for some reason it doesn't come out grouped as I want it to!! anyone
>know why??? I want it to come out like this...
>
>1--Family Fun 4 Package 22.0000
>1--sdffdsdf 22.0000
>2--Monkey Bear 22.0000
>2--dasw 2.0000
>2--asdads 44.0000
>
>but it comes out in this order instead!!!
>
>1--sdffdsdf 22.0000
>2--Monkey Bear 22.0000
>2--dasw 2.0000
>1--Family Fun 4 Package 22.0000
>2--asdads 44.0000
>
>here's the code
>
><CFQUERY DATASOURCE=#dsn# name="get_prod">
>SELECT name, price, show, prod_type_id, id
>FROM prod
></cfquery>
>
><TABLE CELLSPACING="4" CELLPADDING="0" BORDER="0" bgcolor="#E7E7DA">
><cfoutput query="get_prod" group="prod_type_id">
>
><TR>
><TD>#Prod_type_id#--#name# </td><TD>#price# &nbs
>p;</td>
></tr>
></cfoutput>
></table>
>
>PLEASE HELP!
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
