Hi

I need help as how to bin the values for the IN Query,

Assume there are 3 userid and I make a string line ?,?,? in the IN query
my @userid=('1','2','3');

say at first I prepare a query and store this in variable "$result";

my $query="select name from person where userid IN(?,?,?);
my $result= $conn->prepare($query);
$result->execute(@$userid);

I am not getting the value. I understand BIND can be done with a scalar value. So how do I accomplish this...

Thanks
anish


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to