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
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
On Wed, 13 Oct 2004 20:25:48 -0700, Chris <[EMAIL PROTECTED]> wrote:
>> create table test_table
>> (d date not null,
>> name char(32) not null,
>> loc integer not null,
>> type integer not null,
>> amount integer,
>> primary key (d, name, loc, type));
snip snip
> This is how