An Introduction to Class::DBI - First Example
|
19
|
|
Scalability - DBI
With DBI alone, more code means setting up more queries
my $find_winner = $DBH->prepare(<<EOQ);
SELECT film_id
FROM nominations
WHERE takes_the_oscar = 1
AND year = ?
AND type = ?
$find_winner->execute(1965, 'Best Editing');
my ($film) = $find_winner->fetchrow_array;
|
|