Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^2: storing queries in an array and execute

by kaka_2 (Sexton)
on Nov 25, 2016 at 09:59 UTC ( [id://1176530]=note: print w/replies, xml ) Need Help??


in reply to Re: storing queries in an array and execute
in thread storing queries in an array and execute

if i remove the qx then it is just printing the queries whereas i want to execute These queries.
  • Comment on Re^2: storing queries in an array and execute

Replies are listed 'Best First'.
Re^3: storing queries in an array and execute
by choroba (Cardinal) on Nov 25, 2016 at 10:42 UTC
    Ah, then keep the qx and remove the Dumper.

    But you should use DBI with DBD::mysql instead of shelling out.

    ($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord }map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,

      if i remove Dumper then also it gives error and that i why i thougt to use Dumper.

      with DBI, i have Problem with missing Module DBD and that i why i am trying out directly with mysql -e.

        > if i remove Dumper then also it gives error and that i why i thougt to use Dumper.

        It would be helpful to include the error here, too. It seems it was the following one:

        sh: -c: line 0: syntax error near unexpected token `0x20fca70' sh: -c: line 0: `SCALAR(0x20fca70)' sh: -c: line 0: syntax error near unexpected token `0x20fcab8' sh: -c: line 0: `SCALAR(0x20fcab8)'

        You should also remove backslashes from the array assignment. Backslash creates a reference.

        my @QXXXX = ( $Query1, $Query2 );

        ($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord }map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,

        Are you having problems installing the module? If so what are they?

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (None)
    As of 2024-04-25 01:51 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      No recent polls found