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..
my @array= ($result=~ s/\"//g);
this will push all result value into variable and you can use through
+out in program.
Hope this will help.