good chemistry is complicated,
and a little bit messy -LW
DBD and bind_param (Oracle)by Skeeve (Vicar)
|on Dec 09, 2010 at 10:35 UTC||Need Help??|
Skeeve has asked for the
wisdom of the Perl Monks concerning the following question:
I'm trying to use a bind variable in a SELECT ... IN statement, but can't figure out how to do it.
This one works:
I simply do a
But trying this:
only works if I bind just one value. Or to be precise: It seems as if it's only possible to supply one value.
So $myvalue="1, 2, 3"; will result in searching for ('1, 2, 3') instead of (1, 2, 3).
is there any way to supply several values for :VAR1?