Hi,
I am using bind variables for executing a select query which uses "in"
operator. Following is the prototype of my code:
$query = "select a from tab where b in (:1)";
@list = {"A","B","C","D"};
$list_values = join("','",@list);
$DBI-> connect (..);
$sth -> prepare($query);
$sth-> execute ($list_values);
$array_ref = $sth->fetchrow_arrayref
This does not return me any values.
I suspect the issue is with the usage of passing up the comma separated
values as the parameter to the execute function.
Thanks,
Nitin
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
