> This gives me an error:
>
> <cfquery name="GetRev" datasource="#application.database#"
> dbtype="ODBC">
> SELECT YEAR,
> QUARTER,
> REF_PERCENT,
> sum(PRICE) AS tot_price,
> sum(REF_RENUMERATION) AS tot_renum
> FROM ORDER_AFFILIATE
> WHERE AFF_ID = '#URL.RecordID#'
> GROUP BY YEAR, QUARTER
> </cfquery>
I think you'll have to group by REF_PERCENT as well.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
