Re: Using variables withing a mysql query

by wfsp (Abbot)

on May 11, 2008 at 15:13 UTC ( [id://685957]=note: print w/replies, xml )

Need Help??

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 );` [download] "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	[reply] [d/l]
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...	[reply] [d/l] [select]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://685957]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others perusing the Monastery: (2)

As of 2024-04-25 19:06 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found