Thanks, that worked!
At 04:42 PM 04/17/2000 -0400, Dave Watts wrote:
> > 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.
------------------------------------------------------------------------------
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.
