Re: MySQL, Perl, and LaTeX: Trying to loop through results by DAY (as a LaTeX section) for custom PDF report

ot; . $date_added->strftime("%a, %d %b %Y ") . "} "; $date = $date_added->strftime("%d");} On Sun, Sep 15, 2013 at 1:16 AM, J M wrote: > > > <http://stackoverflow.com/questions/18809731/mysql-perl-and-latex-trying-to-loop-through-results-by-day-as-a-lat

MySQL, Perl, and LaTeX: Trying to loop through results by DAY (as a LaTeX section) for custom PDF report

I have written a Perl script (shown below) to loop through my MySQL database and then output a .tex file, as a sort of programmed custom report. As it stands, it works rather

DateTime::Format::MySQL not working as expected, throwing error

Hi! I'm writing a simple script to output data from a MySQL database... Eventually I'd like to pipe it all into a .tex file and make a custom pdf out of it. 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 t

Re: error opening file with open function

else { my $err = $csv->error_input; print "Failed to parse line: $err"; } } close CSV; $dbh->disconnect(); [\code] Thanks again for the help. jmd9qs On Sun, Nov 7, 2010 at 9:25 PM, J M wrote: > Ok now that John has helped me realize that I've been ac

Re: error opening file with open function

olders and $dbh->do() instead of $dbh->prepare() and $dbh->excecute(). I'll post updated code when that is done. On Sun, Nov 7, 2010 at 8:58 PM, John W. Krahn wrote: > J M wrote: > >> -- Forwarded message -- >> From: J M >> Date: Sun, Nov

error opening file with open function

-- Forwarded message -- From: J M Date: Sun, Nov 7, 2010 at 8:27 PM Subject: Re: error opening file with open function To: shawn wilson shawn, I pretty sure it's not a permissions thing but here you go: [code] (jmd...@darkstar)-(0)-(07:23 PM Sun Nov 07)-> (~/global_s

Re: error opening file with open function

parameter, try to parse the file by > hard coding its name in the script and let us know the outcome. > > Cheers, > Parag > > > > > On Sun, Nov 7, 2010 at 6:00 PM, J M wrote: > >> Hi all, >> >> I'm having great issues with my program at the moment

Re: error opening file with open function

On Sun, Nov 7, 2010 at 8:13 PM, shawn wilson wrote: > Use strict and warnings. Probably should also use parentheses: > open(CSV, "< $file") > On Nov 7, 2010 9:01 PM, "J M" wrote: > > Hi all, > > > > I'm having great issues with my program a

error opening file with open function

Hi all, I'm having great issues with my program at the moment... it is supposed to take a csv file and parse it, with the output being stored in a MySQL database. The problem I'm having is that the file I need to parse ('ish_history.csv') will not open in the program for some reason. I know the fi