RE: Calendar table workaround>
>A table of dates to which to join other tables,
>ensuring reports that reflect days for which no
>data is available.
I forget the query but I know it can be done. But can't you just have a table
(called calendar?) with each entry having it'
queries.php#20.
PB
-
Jonathan Mangin wrote:
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subject: Re: Calendar table workaround
- Original
> I have no idea what you are asking, which may explain why no one has
replied
> to your question yet.
>
> I've been working with relational databases for 20 years and I've never
> heard the term "calendar table". What are you trying to accomplish? If you
> describe clearly what you are trying to d
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subject: Re: Calendar table workaround
>
> - Original Message -
> From: "Jonathan Mangin
Oops, I meant to post this on the mailing list, not send it to the original
poster.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subjec
I created a calendar table (date only), but all
where clauses include a uid. Is the following a
sane workaround to get a usable calendar table?
Anything else I can do?
my $sth = $dbh->prepare("
create table $temp_tbl
(date date,
uid varchar(14))
select date,
? as uid
from calendar
where date betw
