I second that suggestion. http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:277365
M!ke -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, October 08, 2007 5:45 AM To: CF-Talk Subject: RE: Graphing date ranges... 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
