This

$sth = $db->prepare("SELECT the_name FROM the_table WHERE id=?");
$sth->execute(3);
my ($the_name) = $sth->fetchrow_array;
[download]

Can be converted into this

my ($the_name) = $dbh->selectrow_array(<<SQL, undef, 3);
SELECT the_name FROM the_table WHERE id = ?
SQL
[download]

Although it always feels a little weird using selectrow_array for a single value. But I guess that's what abstraction layers are for :)
HTH

_________
broquaint