> Jim,
>
> I get this error.
>
> Query Of Queries syntax error.
> Encountered "(. Incorrect Select Statement, Expecting a 'FROM', but
> encountered '(' instead, A select statement should have a 'FROM'
> construct.
>
> Thanks,
Will
Sorry, I blanked on the fact that you were doing a QoQ there... use this (not a
QoQ)...
<cfquery name="eachdaystotals" datasource="#VARIABLES.dsn#">
SELECT DATEADD(d,DATEDIFF(d,0,orderdate),0) AS orderdate, sum(ordertotal) AS
ordertotal
FROM tblOrders
WHERE orderdate > #createODBCdate(Now() - 7)#
GROUP BY DATEADD(d,DATEDIFF(d,0,orderdate),0)
ORDER BY DATEADD(d,DATEDIFF(d,0,orderdate),0) DESC
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250549
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
