Re^2: DBD and bind_param (Oracle)

Not the answer I wanted to read but at least I don't need to search any further.

Thanks to both of you.

s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
+.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e

Comment on Re^2: DBD and bind_param (Oracle) Select or Download Code

Replies are listed 'Best First'.
Re^3: DBD and bind_param (Oracle) by herveus (Prior) on Dec 09, 2010 at 15:55 UTC
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	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: DBD and bind_param (Oracle)
by herveus (Prior) on Dec 09, 2010 at 15:55 UTC

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

[reply]
[d/l]