----- 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" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Wednesday, January 04, 2006 10:45 AM > Subject: Calendar table workaround > > > >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 between ? and ?"); > > $sth->execute($uid, $bdate, $edate); > > > > 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 do, perhaps someone can help you > devise a way to do it in MySQL. > > Rhino > > A table of dates to which to join other tables, ensuring reports that reflect days for which no data is available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]