Re^3: DBD and bind_param (Oracle)


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

Re^3: DBD and bind_param (Oracle)

by herveus (Prior)

on Dec 09, 2010 at 15:55 UTC ( [id://876279]=note: print w/replies, xml )

Need Help??

in reply to Re^2: DBD and bind_param (Oracle)
in thread DBD and bind_param (Oracle)

Howdy!

Now, there are other ways to work the problem that retain the use of bind variables. Consider:

my @values = qw/1 2 3/;
my $sql = 'select * from foo where x in (' . join(', ', ('?') x @in_va
+lues) . ')';
$dbh->prepare($sql)->execute(@values);
[download]

This preserves the use of placeholders and the benefits therefrom while adapting to the changing number of parameters. You can't avoid constructing the query to fit the data.

yours,
Michael