Help for this page

Select Code to Download


  1. or download this
    my @fields = keys(%hash);
    my @params = @hash{@fields};
    my $query = "SELECT row_id FROM Table WHERE " . 
                 join(" AND ", map {"$_ = ?"} @fields);
    
  2. or download this
    my @fields = keys(%hash);
    my $query = "SELECT row_id FROM Table WHERE " . 
                 join(" AND ",
                      map {"$_ = " . $dbh->quote($hash{$_})} @fields);