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!