n I do something like:
if( ) {
other stuff . . .
}
And maybe that would enter the code block once the data starts streaming?
-Original Message-
From: Balint, Jess [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 3:38 PM
To: 'Timothy Johnson'
Cc: '[EMAIL PROTECTED
34 PM
To: 'Balint, Jess'; 'Nikola Janceski'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Sending Command Output over Net::FTP
Do you NEED the return code from the system call? Is there some text
returned when you perform the query to determine if it was successful? If
so, you
/ || ftpsend($output);
-Original Message-
From: Balint, Jess [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:28 PM
To: 'Nikola Janceski'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Sending Command Output over Net::FTP
I think open() is giving me the process ID of the query.
a Janceski
Cc: '[EMAIL PROTECTED]'
Subject: RE: Sending Command Output over Net::FTP
yes... but I don't think you are checking the exit status if that's all you
are doing, don't know much about the bit status it returns but it's the same
for system and open for a comma
Sent: Monday, April 15, 2002 3:12 PM
> To: 'Nikola Janceski'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Sending Command Output over Net::FTP
>
>
> Can I still receive the exit code from that command that way?
> That is how I
> am testing if the query ran
ay, April 15, 2002 3:17 PM
To: 'Balint, Jess'; '[EMAIL PROTECTED]'
Subject: RE: Sending Command Output over Net::FTP
you probably want to use open();
open(COMMAND, " |") or die "cannot execute: $!";
while(){
#ftp stuff
}
> -Original Message-
ROTECTED]'
> Subject: Sending Command Output over Net::FTP
>
>
> Hello all, now that this works . . .
> I am trying to send the output from a database query over and
> FTP connection
> into a remote file. When I run it like:
>
> sqlrun mysqlfile.sql | myperlscript.
Hello all, now that this works . . .
I am trying to send the output from a database query over and FTP connection
into a remote file. When I run it like:
sqlrun mysqlfile.sql | myperlscript.pl
It seems to work alright. What I would like to do is have the perl scripts
kick off the query through
