Guys,
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>
The error:
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-00979: not a GROUP BY
expression
Data Source = "REISDB"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (9:1) to (9:73).
Any ideas? Thanks!
------------------------------------------------------------------------------
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.
