Oct 26, 2011, 8:50 AM
Post #1 of 3
Having trouble with a script that isn't reading a CSV log properly. The error I get is as follows:
DBD::CSV::st execute failed
DBD::CSV::st execute failed: Can't call method "column" on an undefined value at /usr/lib/perl5/site_perl/5.8.8/SQL/Statement/Term.pm line 199, <GEN32> line 102.
[for Statement "SELECT email, max(timestamp) AS timestamp FROM log WHERE email = 'firstname.lastname@example.org' GROUP BY email"] at /home/username/emailservice/send.pl line 44.
An excerpt of "log" is as follows:
1318866343,"Robert & Robbie",doe,email@example.com,2011-10-17
The object of the query is to return the most recent time that email address appears in the log. Thanks for any help!
(This post was edited by thatbradguy on Oct 26, 2011, 9:00 AM)