my @values = ( 'SomeValue', 5 );
my $dbh= DBI->connect( $DSN, $user, $pass );
my $SQL = "SELECT * FROM mytable WHERE field1=? LIMIT ?";
my $sth = $dbh->prepare($SQL);
$sth->execute( @values );

##</code><code>##

$sth->execute( 'SomeValue', 42 );