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

Re^6: Query Does not work in Spreadsheet::WriteExcel

by choroba (Cardinal)
on Jul 24, 2020 at 19:21 UTC ( [id://11119772]=note: print w/replies, xml ) Need Help??


in reply to Re^5: Query Does not work in Spreadsheet::WriteExcel
in thread Query Does not work in Spreadsheet::WriteExcel

Did you use double quotes in Perl to store the sql query?

map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]

Replies are listed 'Best First'.
Re^7: Query Does not work in Spreadsheet::WriteExcel
by dirtdog (Monk) on Jul 24, 2020 at 21:03 UTC

    No. I did not use any quotes to store the query.

      How then did you generate the query string in Perl? Did you use a here-doc? Some variations of here-doc handle escapes (and interpolation).

      I think the point choroba is making is that a double-quote string constructor processes escapes (and also interpolates):

      c:\@Work\Perl\monks>perl -wMstrict -le "my $sq = '\Quick and \Easy \Upper \Limit \\UTTER \\LAUGH \Wow'; print qq{>$sq<}; " >\Quick and \Easy \Upper \Limit \UTTER \LAUGH \Wow< c:\@Work\Perl\monks>perl -wMstrict -le "my $dq = qq{\Quick and \Easy \Upper \Limit \\UTTER \\LAUGH \Wow}; print qq{>$dq<}; " Unrecognized escape \W passed through at -e line 1. >uick\ and\ asy PPER imit \utter \laugh wow<
      (Do you have warnings enabled?)


      Give a man a fish:  <%-{-{-{-<

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2024-03-29 10:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found