Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Using variables withing a mysql query

by wfsp (Abbot)
on May 11, 2008 at 15:13 UTC ( #685957=note: print w/replies, xml ) Need Help??


in reply to Using variables within a mysql query

Is the SQL quoted with single or double quotes?
  • Comment on Re: Using variables withing a mysql query

Replies are listed 'Best First'.
Re^2: Using variables withing a mysql query
by sulfericacid (Deacon) on May 11, 2008 at 17:16 UTC
    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

      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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://685957]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2022-01-17 03:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (51 votes). Check out past polls.

    Notices?