<CFQUERY DATASOURCE=#dsn# name="get_prod">
SELECT name, price, show, prod_type_id, id
FROM prod
Order by prod_type_id
</cfquery>
<TABLE CELLSPACING="4" CELLPADDING="0" BORDER="0" bgcolor="#E7E7DA">
<cfoutput query="get_prod">
<TR>
<TD>#Prod_type_id#--#name# </td><TD>#price#
</td>
</tr>
</cfoutput>
</table>
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Koo Pai Lao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 3: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#
</td>
</tr>
</cfoutput>
</table>
PLEASE HELP!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
