Help for this page

Select Code to Download


  1. or download this
    my @query_ids = (5,4,3,2,1);
    my $sql = q/select rec_data from foo where id in (/ . join(",", @query
    +_ids) . q/) order by id/;
    my $results = $dbh->selectall_arrayref($sql);
    
  2. or download this
    my @query_ids = (5,4,3,2,1);
    my $sql = q/select rec_data from foo where id in (/ . join ",", ("?") 
    +x @query_ids .q/) order by id/; print $sql;'
    select rec_data from foo where id in (?????) order by id
    my $results = $dbh->selectall_arrayref($sql, undef, @query_ids);