On Tue, May 12, 2009 at 5:40 PM, Bruce Ferrell wrote:
> Given the following code:
>
> $sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
> a.reason, a.tl
> INTO OUTFILE '/tmp/result.csv'
> Can you tell me why I'm getting this error:
>
> DBD::mysql::st execute failed
Given the following code:
$sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
FROM alerts a
WHERE a.stamp BETWEEN ? AND ?
Hi Frank,
I am not sure what exactly you are doing here.
By seeing message I can say two things.
1) You have not installed the listed cpan modules (Buffer.pm etc ).
2) If modules are installed already then there is a possibility that, you have
not given correct path in your Perl script where
Dear Users,
in order to achieve SFTP-Tranfer I added the line 14
use Net::SFTP;
which caused an error as
Compilation failed in require at C:/Perl/lib/Net/SSH/Perl/Util.pm line 56.
BEGIN failed--compilation aborted at C:/Perl/lib/Net/SFTP/Buffer.pm line 9.
Compilation failed in require at C:/Perl/l
