Help for this page

Select Code to Download


  1. or download this
    my $sql = join(",", @allsearchterms);
    my $sth = $dbh->prepare("select * from table where value in($sql)");
    # You need to place qutes arount the sql-items, but you'll get the poi
    +nt here...
    $sth->execute();
    
  2. or download this
    
    my $qm = join ',', ('?') x @allsearchterms;
    my $sth = $dbh->prepare("select * from table where value in($qm)");
    $sth->execute(@allsearchterms);