Re^4: Executing multiple mysql commands in a single execute() call.

in reply to Re^3: Executing multiple mysql commands in a single execute() call.
in thread Executing multiple mysql commands in a single execute() call.

why not you push value in variable( scalar,array- if multiple) and then use further. This is easy step to go ahead. For example.

my $result = qx!kfsql -S Servername -D database -F e -s , -c \"select 
+field1 from test where criteria = "C" and some_date \!= $processdate 
+order by field_time desc\"!;

if want to push in array then..
chomp $result;
my @array= ($result=~ s/\"//g);

this will push all result value into variable and you can use through 
+out in program.
[download]

Hope this will help.

Comment on Re^4: Executing multiple mysql commands in a single execute() call. Download Code

In Section Seekers of Perl Wisdom