my $sth = $dbh->prepare("
        INSERT INTO foo (first_col,second_col) VALUES (?,?)
    ");
    $sth->execute( $string, $number );