Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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

by bimleshsharma (Beadle)
on May 30, 2012 at 12:23 UTC ( #973275=note: print w/ replies, xml ) Need Help??


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.
Hope this will help.


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://973275]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2015-07-07 06:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls