Re: Date range with empty rows (Was: Intra-table join)

2004-10-14 Thread SGreen
I have the same issue (missing dates) with my graphing widget, too. I worked around my problem by using script to create a temp table that contains all of the dates that cover the range of dates I want to chart then left join the data tables to my temp table. Sure it's a small memory load, and

Re: Date range with empty rows (Was: Intra-table join)

2004-10-14 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Partap Davis <[EMAIL PROTECTED]> writes: > I'm graphing the data from this query using dates on the x axis. The > input to my graph module (GD::Graph) requires a constant-length list. > So if any days in my selection range have no data, I need to fill the > space