I guess to be fair, I should add that a similar result could be achieved in SQL by declaring a temp table with default column values of zero, pre-populating it with all possible dates etc., then going back and updating the actual values into that table. Then select everything from the temp table, and you will have your data across the entire range.
~Brad -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 11:33 AM To: CF-Talk Subject: RE: Pivot table confusion Do you have an example of what you mean? Maybe I've been staring at it too long but i just don't see how to populate non existent data. ====================================== Yeah, here's a VERY quick example. It doesn't involve a pivot table, but it shows what I mean by getting around missing values. The more I look at it, the more I hate it-- but like I said-- quick and dirty... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
