Re: Values concatenation for SQL query

[LanX]

you most probably want to pass an array @values with 3 arguments or 3 separated $scalars, and not one concatenated string.

edit

what's wrong with...

$sth->execute( "${middle}%" , $last, $first );

?

[Anonymous Monk]

I know that works, I would like to know why it wouldn’t accepted the way I am trying to do it, and if there is a way of doing it.

[Corion]

If you have three placeholders, DBI expects three values to be passed in for the three placeholders. There is no way around it.

Maybe you want a way to extract three values out of your one concatenated string, but you haven't described your problem in a way that I can easily infer that from what you've told us so far.

If you have the three values separated already, I recommend keeping them separate.

[LanX]

> why it wouldn’t accept

because with 3 ? exactly 3 scalar arguments are expected and you only pass one

> if there is a way of doing it.

As already explained you could pass an array @values which is initialized with something like @values=($a,$b,$c)

> the way I am trying to do it

are you probably trying to code like in Tcl where (IIRC) comma space separated strings and arrays belong to the same data type? That's not Perl, sorry.