Will Tomlinson wrote: >> Do you want to have a count or sum of the orders in the chart? > > A sum of the orders. I ALMOST have it with this. It's not grouping correctly > tho cause I have multiple rows for one particular day showing. > > <cfquery name="getsevendayorders" datasource="#VARIABLES.dsn#"> > SELECT orderdate, ordertotal > FROM tblOrders > WHERE orderdate > #createODBCdate(Now() - 7)# > ORDER BY orderdate DESC > </cfquery> > <cfquery name="eachdaystotals" dbtype="query"> > SELECT orderdate , Sum(ordertotal) > FROM getSevenDayOrders > GROUP BY orderdate > </cfquery> > > I figure once I get this, I'll use the query attribute in my cfchart. I could > run some more queries I guess and plot each point, but heck, this should be > able to be done. >
Try this... SELECT DATEADD(d,DATEDIFF(d,0,orderdate),0) AS orderdate, sum(ordertotal) FROM getSevenDayOrders GROUP BY DATEADD(d,DATEDIFF(d,0,orderdate),0) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:250543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
