On 05/09/2013 02:28, J M wrote:
However, I'm running into a problem: the FIRST instance of
DateTime::Format::MySQL works perfectly... but when I get to the second
one, it throws me this error:
Use of uninitialized value $input in concatenation (.) or string at
/usr/local/share/perl/5.14.2/
DateTime/Format/Builder.pm line 154.
Invalid date format: at ./logbook.pl <http://logbook.pl> line 29
my $sth = $dbh->prepare("select l.id, l.date_added, l.username,
l.entry, c.comment_date_added, c.username as cuser,
c.comment from logbook as l
left join comments as c on l.id = c.logbook_id
order by l.date_added desc");
Run that query inside the mysql client, and you will probably see that
c.comment_date_added is NULL.
--
Ruud
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
