Summary => RE: [htmltmpl] [Question] H::T and DBI

[C H. <hag...@ep...>]

Thanks to all for the suggestions
(the speed and number of the responses was great)

I'm going to run with Puneet's suggestion:

   # Fetch the results as a ref to an AofH
   my $res = $sth->fetchall_arrayref({});
   # Assign the ref to a var in the template
   $t->param(RES => $res);

for the simple reason:

"Specify the column names you want to retrieve,
and the column names automatically become
the names of the TMPL_VARs."

This seems the simplest way to go for my application
 From what I understand, working with hash_ref 's
is supposed to be inefficient (performance-wise),
but in my case, I'm pursuing such a light
weight database that I don't think it's an issue.


Carl Hagstrom
hag...@ep...