Hey pal, If you're looking to fill in the holes where there is no data for a particular date the best way to do this is with a Calendar table in your database, you can then select the desired date range from this and LEFT OUTTER JOIN it to your table with your statistics data, that way It'll return a row for every date in the range, regardless of whether you have data for that date or not, so you get no gaps.
It's more of a SQL type thing so you might be better off asking there, and looking around for some help building and populating a Calendar table, it's not an overly complicated task, but a calendar table will really help you out for this and many other tasks too, I'd highly recommend one. Let me know if you need any more help Jay, Rob -----Original Message----- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 08 October 2007 10:44 To: CF-Talk Subject: Graphing date ranges... I have a cfchart displaying dates along the X axis, is there any way to get ColdFusion to treat these as a scale so that a 7 day gap in the data would stretch the graph out to interpolate the missing days? CFChart does have an "xAxisType" attribute but to set it to scale the data must be numeric and I really want to keep the data displaying as formatted dates. -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007 18:12 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
