or download this
$sql = "SELECT record_id, attribute_1, attribute_2 FROM theTable";
$sth = $dbh->prepare($sql) or die("Could not prepare!" . $dbh->errstr)
+;
...
$template->process($template_file, $vars)
|| die "Template process failed: ", $template->error(), "\n";