Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Values concatenation for SQL query

by KurtSchwind (Chaplain)
on Mar 10, 2015 at 12:33 UTC ( [id://1119481]=note: print w/replies, xml ) Need Help??


in reply to Values concatenation for SQL query

What Lanx said.

You have three variable bindings in your prepared sql, and you are passing in one variable. The execute is expecting to find 3 variables to pass to the bindings. What you probably want to do is something like this

my @bindings = ( $middle, $last, $first); ... $sth->execute(@bindings); ...

$string is a single scalar.

--
“For the Present is the point at which time touches eternity.” - CS Lewis

Replies are listed 'Best First'.
Re^2: Values concatenation for SQL query
by Anonymous Monk on Mar 10, 2015 at 12:42 UTC
    Thank you, just tried using an array as I read your post, but thanks a lot, it works now!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2024-04-23 22:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found