>Sorry, I blanked on the fact that you were doing a QoQ there... use this (not >a QoQ)...
Dude, this works like a champ! Only one little problem left. THe date is ugly in the cfchart. The data is all correct and grouped nicely tho'. Is there some way to change the look of the datetime? I looked into convert() in sql server but can't get it to work. <cfchartseries type="bar" query="getsevendayorders" itemcolumn="orderdate" valuecolumn="ordertotal"> Thanks a ton! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:250553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
