Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: Using variables withing a mysql query

by sulfericacid (Deacon)
on May 11, 2008 at 17:16 UTC ( #685964=note: print w/replies, xml ) Need Help??


in reply to Re: Using variables withing a mysql query
in thread Using variables within a mysql query

The statement is actually
my $data = qq( mysql_here );


"Age is nothing more than an inaccurate number bestowed upon us at birth as just another means for others to judge and classify us"

sulfericacid

Replies are listed 'Best First'.
Re^3: Using variables withing a mysql query
by psini (Deacon) on May 11, 2008 at 19:43 UTC

    This should be equivalent to double quotes. What do you get from a print $data; after your statement above?

    If you get exactly the query (SELECT id, name, location FROM book WHERE 1 ORDER BY id DESC) and it doesn't work as expected, perhaps you should post more of the surrounding code...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://685964]
help
Chatterbox?
[Corion]: So maybe I should investigate how to plug in a cache in front of DBIx::Class so I can do a ->selectall_hashre f and then satisfy the "sub"-selects from that cached single SELECT statement ...
[erix]: then you might as well send that patch to the DBIC guys :)

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2017-09-25 11:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (279 votes). Check out past polls.

    Notices?