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 [EMAIL PROTECTED]
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Html-template-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/html-template-users
