Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Variable is filled with column name not data, can't figure out why.

by grep (Monsignor)
on Jul 17, 2007 at 03:20 UTC ( #626956=note: print w/replies, xml ) Need Help??


in reply to Variable is filled with column name not data, can't figure out why.

Straight from the DBI Docs:
With most drivers, placeholders can't be used for any element of a statement that would prevent the database server from validating the statement and creating a query execution plan for it. For example: "SELECT name, age FROM ?" # wrong (will probably fail) "SELECT name, ? FROM people" # wrong (but may not 'fail')

So you'll need to change your code to:

$sth = $dbh->prepare(qq~select $rating from FanRatings where Title = ? +~) or die $DBI::errstr; $sth->execute($filename) or die $DBI::errstr;

Replies are listed 'Best First'.
Re^2: Variable is filled with column name not data, can't figure out why.
by Eagle_f90 (Acolyte) on Jul 17, 2007 at 23:02 UTC
    Now that you point that out I remember reading it last week when learning about the place holders. It just never poped back to me as the problem. Thanks for the help!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://626956]
help
Chatterbox?
[jdporter]: is there a module for expanding tabs in text?
[jdporter]: A: yes.
[Lady_Aleena]: I don't know how hard it will be to get out of that mess.
[LanX]: M-x untabify
[choroba]: I don't think they're multiple people. I was told "he or she" sounds old-fashioned and "they" is the way to say it
[pryrt]: Those others were definitely offensive or unequivocably rude, I agree.
[choroba]: (well, it comes from the 14th century, so labelling it as "modern" doesn't seem appropriate)
[Your Mother]: "They" is becoming accepted but it irritates me sometimes. I tend to just pick she or he randomly or try to use "one."
LanX thinks it is appropriate here :)
[Your Mother]: They would think so.

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (17)
As of 2017-05-24 20:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?