Help for this page

Select Code to Download


  1. or download this
      $query .= ' where upper(env)=upper(?)';
      push(@sql_params,$query(env});
    ...
    
      my $sth = $dbh->prepare($query) or die;
      $sth->execute(@sql_params);
    
  2. or download this
    if (defined($query{component}))
      push(@querypart, 'where upper(component) = upper(?)';
    ...
    print $query;
    my $sth = $dbh->prepare($query); 
    $sth->execute(@sql_params);